Advanced search operator "IN" in field using "multiple" to select not working as expected

solucionesmipc · Post by **solucionesmipc** » Sun Mar 17, 2024 7:35 pm

Hi.
i tried to use "in" operator in advanced search and no results when use more than 1 value in search option.

the debug sql query is not using quotes for every value. ex: SELECT status, '', COUNT(id) FROM vvzdata WHERE status IN ('option 1,Option2') AND client = 517

thanks.

mobhar · Post by **mobhar** » Mon Mar 18, 2024 9:50 am

You may simply use Recordset_Searching server event in order to add your own search criteria.

arbei · Post by **arbei** » Mon Mar 18, 2024 10:49 am

Note that you need to separate your input values by "|".

yinsw · Post by **yinsw** » Fri Mar 22, 2024 12:36 am

They have change the logic for this compare to earlier version.

For SELECT input type and multiple is selected, you use equal (=) operator.