Grouping filter conditions
If you create complex filters with multiple conditions, you might want to change the order of precedence of the conditions. To do this, you can group conditions so that an And or Or operator applies to the group rather than to an individual condition.
Once you have grouped two or more conditions, you also have the option to use the NOT operator. Selecting NOT means that the filter only includes cases where the grouped conditions are not true.
To group conditions
1 In the Filter pane, use Shift+click to select the conditions that you want to group, and click the Group button
on the Filter toolbar.
A box is displayed around the grouped conditions.
In the Filter Syntax pane, the grouped conditions are surrounded by parentheses (), for example:
age.ContainsAny({E1116_years}) And (biology.ContainsAny({Yes}) Or before.ContainsAny({No}))
2 To ungroup conditions, select the grouped conditions, and then click the Ungroup button
on the Filter toolbar.
See also