Hi,
I have an extended search for a specific field via checkboxes. The field can contain multiple values (standard PHPMaker). There are about 10 values/choices.
When I select multiple checkboxes, the system performs an OR-operation. Is there a way to change this to AND?
E.g. when I select choice 2 and 4, it now returns all the records where the field contains choice 2 OR choice 4 (or both).
I would like to only retrieve records where the field contains both choice 2 AND choice 4.
Any idea?
Forgot to mention: you might suggest to use Operator 2, but I do not want to make use that as the search pane would become too busy and also because more than 2 choices are possible.
Try: Tools → Advanced Settings → Search multiple value option = 2
Thanks! Works perfect!
Is there a way to change this depending on the situation?
E.G. in list A, I need AND condition and in list B I need OR condition, or even in the same list with 2 different search fields…?
Use Recordset_Searching server event, where you can build your search filter completely on your own.
OK. Thanks!