I had a simple question regarding doing manual searches within servoy:
Is there a list somewhere that defines the functions of all the wild card or special charecters you can use when doing a manual search. If I enter %name%, I get anything with the string name. If I enter % in a field or != , etc… I get differernt results.
I use manual searchs allot to find data quickley from a admin perspective, I am not sure of all the charecters that can be used and what the expected results are.
Also, If I find a set of data, I see that I cannot omit found set from the menu, to view the records not included in the search. I know I can do this via a method, or a search for opposite criteria.
Example I seach a field for ‘%’ and get a set or records that contain values in this field, if I try ‘!=%’ or ‘’ , I don’t get what I any results. Thats where I need to find a list of all the special charectures I can use in a manual search with definitions.
Thnaks allot for any help on this.