Apply Column Filters

Column filters are applied using the facilities provided in the filtering row, which displayed beneath the column headings of a grid. If this row is not displayed for a grid, turn it on by checking the Column filtering checkbox in the Grid Options section of the View Tab.

To apply a basic column filter:

1. Select a filter criterion, for example, Starts with, Contains or Does not end with from the drop-down list displayed by clicking the left-hand button in the filtering row of the column.

   

2. If a value is selected without a criterion being selected, the Starts with criterion is applied by default.

3. Then either enter a value in the field to the right of the criterion selection button, or click on the button to the right of this field and select a value from the list that is then displayed.

   

4. The list contains every value in the column, plus Custom, Blanks and NonBlanks. If Custom is selected the window used to construct advanced grid filters is displayed. Refer to Apply Advanced Grid Filters for further information.

5. If Blanks is selected rows without a value in the column are displayed when the filter is applied. If NonBlanks is selected rows with a value in the column are displayed.

6. The selected value is displayed in the field between the two buttons.

7. The filter is then applied to the grid.