Wildcard in search widget

SarahNoakes1 — Tue, 22 Dec 2020 15:33:47 GMT

I'm using the Search widget to query a feature layer. When a user enters a search string with more than one word e.g. WORDA WORDB the widget searches for the whole phrase "WORDA WORDB" within the search field:

SEARCHFIELD LIKE '%WORDA WORDB%'

So the user has to enter the precise text that is stored in the field being searched in order to get the correct results. If, for instance, the data contained a record with "WORDA, WORDB" in the search field, then this record would not be returned.

I would like the search to look for each word of the search string separately within the search field:

SEARCHFIELD LIKE '%WORDA%' AND SEARCHFIELD LIKE '%WORDB%'

I know we could tell the users to include the wildcards themselves and enter the search string as 'WORDA% %WORDB' but they may not be very IT-literate, so we don't feel this is a viable solution.

Re: Wildcard in search widget

LiamKerr — Thu, 01 Feb 2024 01:26:23 GMT

Thanks for the help, chur bro

idea Wildcard in search widget in ArcGIS Web AppBuilder Ideas

Wildcard in search widget

Re: Wildcard in search widget