Page 1 of 1
Advanced search operator "IN" in field using "multiple" to select not working as expected
Posted: Sun Mar 17, 2024 7:35 pm
by solucionesmipc
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.
Re: Advanced searh operator "IN" in filed using "multiple" to select not working as expected
Posted: Mon Mar 18, 2024 9:50 am
by mobhar
You may simply use Recordset_Searching server event in order to add your own search criteria.
Re: Advanced search operator "IN" in field using "multiple" to select not working as expected
Posted: Mon Mar 18, 2024 10:49 am
by arbei
Note that you need to separate your input values by "|".
Re: Advanced search operator "IN" in field using "multiple" to select not working as expected
Posted: Fri Mar 22, 2024 12:36 am
by yinsw
They have change the logic for this compare to earlier version.
For SELECT input type and multiple is selected, you use equal (=) operator.