Conditions pane

The Conditions pane is the middle pane on the right side of the Query Builder Editor. It allows you to define qualifications and insert security filters that will be included in the WHERE or HAVING clause of your SQL queries. The qualifications filter the data that appears on the resulting report.

Conditions that qualify on an aggregation are automatically included in the HAVING clause of the SQL query. Any conditions that do not qualify on an aggregation are automatically included in the WHERE clause of the SQL query.

To create a qualification in the Conditions pane, see Creating a qualification in Query Builder.

To create a security filter qualification in the Conditions pane, see Creating a security filter in Query Builder.