Note: your browser is configured to prevent scripts from running. This online documentation relies on scripts for navigation, table of contents, search, and other features. To make full use of the documentation, adjust your browser settings to allow scripts to run. See Adjusting browser settings for more information.

Filtering Your Results > Advanced Filter Conditions >

Grouping Filter Conditions

If you create complex filters with multiple conditions, you may 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

► In the Filter pane, use Shift+click to select the conditions that you want to group, and choose the Group button on the Filter toolbar:

A box is displayed around the grouped conditions.

Note: If you look at the expression in the Filter Syntax pane, you will also see that the grouped conditions are surrounded by parentheses (), for example:

age.ContainsAny({E1116_years}) And (biology.ContainsAny({Yes}) Or before.ContainsAny({No}))

► To ungroup conditions that you have previously added to a group, select the grouped conditions and choose the Ungroup button on the Filter toolbar.

The grouping is removed from the conditions.