Filter workspace grid data

For grids that appear in the tabbed workspace, the Properties window, and dialog boxes, you can filter the rows that appear in the grid by its column data. The rows can be filtered by one or more columns.

Each column in the grid has a filter control, as shown below.

Select an operator

The operator determines how the content to be searched will be evaluated.

An icon that indicates the currently selected operator appears here. Click the operator icon to open the menu of available options.

Enter the content to search on

You can enter the content to search on in the following ways:

• By typing the content. As you enter content, the rows are filtered automatically to those that match what you have entered so far.

• By selecting one of the existing values in the column. Open the operand menu to see this list. Column values are listed following the (Custom), (Blanks), and (NonBlanks) options.

  

• By filtering the rows on whether they have a value in the column.

  To filter on rows that do not have a value in the column, in the operand menu click (Blank).

  To filter on rows that do have a value in the column, in the operand menu click (NonBlanks).

• By building a custom filter. See the following subtopic.

Build a custom filter

For a given column, you can create a custom filter that has more than one filter condition.

1. On the operand menu, click (Custom).

   The Custom Filter Selection dialog appears.

   

   Note: The condition grouping functions are not available.

2. Click Add Condition to add a condition and set its operator and operand.

   You can delete conditions by selecting them and clicking Remove Conditions.

3. If there's more than one condition, determine whether they are ANDed or ORed by clicking Toggle.

4. To save your changes to the custom filter, click OK.

Clear a filter

Click the filter's clear icon, highlighted below.