Default Wildcard, Case-Insensitive Searches

Hi All,

Is there any way to change a solution so searches are always in the form “#smi%” (to search for smith)? I don’t want to have to train people to use a # and % sign on every search.

The only way i can see that you can do it is to have a button that manipulates the data in the fields before running the search, but this isn’t reliable because people can still hit ‘enter’ to trigger the search…

Any help appreciated! Thank you!

Hi cvd

Welcome to the Servoy Forum.

In Servoy you can set the ‘onAction’ property to fields and labels as well as buttons. In Designer mode click on your Search_Input field - most people use a global_field here - and set the onAction property to point to your search method. Then users can either click the Search button or hit the key.

You can then capture the Search_Input field data - validate if necessary - and add # % as required.

HTH

Graham Greensall
Worxinfo Ltd