Construct filters

You use the Add Query or Filter dialog box to create or edit a filter graphically.

To construct a filter

1. If you want to change the filter name, type a new unique name in the Filter Name box.

2. Add filter criteria to the construction area by selecting a column name on the left and clicking the right arrow button. When you add filter criteria to the construction area, they are automatically logically connected by AND.

   

3. If necessary, remove filter criteria by selecting them in the filter construction area and clicking the left arrow button.

4. To change the logical operator, select it in the filter construction area, and then either:

   • Click AND or OR

   • Right-click and select AND or OR from the shortcut menu

5. To group filter criteria logically, either:

   • Drag a filter criteria in the construction area over another filter criteria

   • Select one filter criteria, click Group, and then click the other filter criteria

     By default, the filter criteria are logically grouped with AND. If necessary, you can select the AND item in the tree and click OR to change it to an OR grouping.

     

6. Assign values to filter criteria.

   Note: If you are using the Value column as a filter criteria, you may get unexpected results at run time. The items in the Value column are sorted alphabetically, not numerically. This is because the Value column can contain strings.

   Do the following:

   1. Select a filter criteria in the construction area.

   2. Select an operator from the Operator list.

   3. Type or select a value in the Value box.

   4. Click Set. The filter criteria is updated in the construction area.

7. To cut, copy, or paste individual filter criteria or filter criteria branches, right-click on the filter criteria and select the appropriate option from the shortcut menu.

8. When you are done, click OK.