Structuring the search criteria
I've tried to find the answer to this before posting but it's really hard to know what to search for.
Using Data Bridge DataAssist Search, I want the criteria to be like this:
var1=1 AND var2=1 AND var3 contains $search OR var4 contains $search
But, from what I can see there is no way of putting () in and this is crucial. I want it to be like this:
(var1=1 AND var2=1) AND ((var3 contains $search) OR (var4 contains $search))
How can I achieve this? It goes without saying that the parenthesis can completely change the results.
Thanks in anticipation.