Filter Queries

SQL queries constructed in the Query Builder can be filtered by including the WHERE clauses in the query. Filtering can be applied to underlying or aggregated data.

To filter a query, deselect added tables and click the ellipsis button next to the Filter field in the Query Builder.

wdd-invoke-filter-editor-for-query

This invokes the Filter Editor dialog which allows you to build filter criteria.

wdd-filter-editor-filter-query

See Filtering to learn how to use this dialog.

The Filter Editor enables you to compare field values with the following objects:

  • Value - Allows you to compare field and static values.
  • Property - Compares different field values.
  • Parameter - Allows you to compare field and query parameter values. You can choose an existing query parameter or create a new one by selecting Create new parameter.

    SqlFiltering_FilterEditor_ParameterDropdown

Note

The Group Filter option from Query Properties allows you to apply filtering to grouped/aggregated data fields by including HAVING clauses in the query. The Group By and Aggregate options in the Query Builder manage Grouping and aggregation.See the Edit Column Settings paragraph in the Query Builder topic for more information.