Search Widget Question

Question

I had a quick question regarding the search widget.

Is it possible to get it to return a result from a partial search without needing % at the end of the search? For example, we have a map with building White Hall listed. How can I get White Hall to show up from searching "White" instead of "White%"?

JoshJones1 · Answer

This thread helped me with two of my three problems I am having with the Search Widget.  Maybe one of the previous posters can help me here.  I was also wondering how to make it possible to only search a portion of a specific attribute.  Let's say I have a "Keywords" attribute column that has many different values that are associated with a specific building, such as departments or services that are located within the specific building.  Is it possible to allow the user to type a value that will be SOMEWHERE within the keywords column, or would I have to make a different column that contains each department/service that I want the users to be able to search?

Any help would be greatly appreciated.

-Josh Jones

BenReilly · Answer

Perfect, that does exactly what I need it to. Thank you for your help!

JonFisher · Answer

To make it case-insensitive as well (e.g. for 'white' to find 'White Hall') you could use something like:lower(PD_NAME) like lower('[value]%')