Inserting Parentheses Around Search Conditions

When you combine search conditions with the And and Or operators, you may not always get the results you expect. For example, suppose you want to find all new issues with priorities ASAP or Today.

Progress = New And
Priority = ASAP Or
Priority = Today

And has a higher precedence than Or, so this query finds all new issues with priority ASAP, plus all issues (not just the new ones) with priority Today.

To find only new issues with priorities ASAP and Today, click the Priority = Today search condition, then click graphics/bAddParenth.png to place parentheses around the conditions joined by Or. For example:

Progress = New And
(Priority = ASAP Or
Priority = Today)

Related Topics

Building Queries