Wildcard in search widget

157
0
12-22-2020 07:33 AM
Status: Open
Labels (2)
SarahNoakes1
Occasional Contributor

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.