Filter Query Results

Use the Results tab in a query tool window to filter query results.

To filter query results

Create a Query or Open an Existing Query.
In the toolbar, click Run. The results appear on the Results tab. The following example shows the Results tab in the Account Analysis window.

Account Analysis window - Results tab

In the column heading of the column to filter, click the Funnel icon. A list of options for the specified column appears.

Query results filter

(All): If selected, the system doesn't filter the results.

(Custom): If selected, allows you to set custom filtering conditions.

(Blanks): If selected, the query results only include accounts with a blank or null value in the specified column.

(NonBlanks): If selected, the query results only include accounts that don't have a blank or null value in the specified column.

Click any value other than (Custom). The list closes and the query results only include the records that match the specified filter.
To set custom filter criteria, do the steps to Set Custom Filter Criteria.