Data Picker - Query Condition
I'm working on setting up query conditions for a data picker and have a question about logic handling.
I have three conditions:
Two of them need to use OR logic between them
The third condition should always be true, so it needs to be combined with the others using AND
Checking the option "Show results matching any condition," it applies OR logic to all three, which doesn’t give the intended result.
Is there a way to mix AND and OR conditions in a data picker query — for example:
(Condition1 OR Condition2) AND Condition3?