A feature I would like to have is to do a search for more than one variable in a field. For example if I have a field called employees, with say Bob, Mary, Jim and Sara I can only search for one of them at a time using the equals advanced search.
Would it be possible to add an "IN" and then the user would have to type the variables in quotes with comas ie "Bob","Mary"
basically writing the where statement in SQL.
Checking NOT would do the NOT IN function of SQL
I am very aware this might confuse users.