Apply Column Filters

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

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 button in the filtering row of the column.

   

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

2. 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.

   

   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.

   • If Blanks is selected, then rows without a value in the column are displayed when the filter is applied.

   • If NonBlanks is selected, then rows with a value in the column are displayed.

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