Filtering Data in Grid

Hiding Data of a Column

  1. Right-click the required column and select Visible Columns from the menu. The Visible Columns dialog box opens.

  2. Deselect the check box next to the column you want to hide in the grid.

    Visible Columns

  3. Click OK to close the dialog box and apply the filter condition.

Filtering Data by Column

  • Click the Filter button in a column header. The drop-down list opens with a set of values encountered in the column and the universal items such as All, Custom, Blanks, and Non Blanks. To view only the rows containing Blanks (NULLs), Non Blanks (not NULLs), or a certain value, select the corresponding item in the list.

  • Right-click the required column, select a filtering condition from the Quick Filter sub-menu.

Quick Filter

When the data is filtered, the column Filter button will be changed to Active Filter to indicate the applied filter. The filter condition appears at the bottom of the grid providing you a one-click quick access to the filter condition parameters. You can manage them in the following ways:

  • To remove all filter conditions, click the Filter Cancel button at the bottom of the grid. To remove the filter condition of one column, right-click this column and select the Clear Filter item from the menu.

  • To switch from the filtered data to the full data display, deselect the Check Box check box at the bottom of the grid.

  • To edit the filter condition, click the Edit Filter button. The Filter Editor Dialog Box opens.

Applying a Custom Filter Condition to Column

  • Right-click the required column and select the Condition Button Condition item from Quick Filter sub-menu. The Filter Editor Dialog Box opens.

  • Build a filter expression by choosing a relation kind and typing values. See below how to create a new filter condition.

Filter Editor

Filter conditions in the Filter Editor dialog box are displayed as a tree with condition and group nodes. A group consists of several conditions or subgroups, united with a logical operator. To change a group logical operator, click it and select another one from the menu. To navigate between conditions and groups, use the UP ARROW and DOWN ARROW keys. To navigate between a condition column, a criteria operator and an operand value, use the LEFT ARROW and RIGHT ARROW keys.

To remove a condition, click the Filter Red condition button or navigate to the condition and press the DELETE or MINUS SIGN key. To remove a group, click its logical operator and select the Remove Group from the appeared menu. You can copy, cut, and paste conditions and groups with CTRL+C, CTRL+X, and CTRL+V keys.

  • Click OK to apply the filter condition to the data in the grid.

Creating a New Filter Condition

  1. Create a new group:

    • Click the upper-level group operator and select Add Group from the appeared menu.

    • Press CTRL+PLUS SIGN.

  2. Create a new filter condition by doing one of the following:

    • Click the upper-level group operator and select Add Condition from the appeared menu.

    • Navigate to a group you want to enhance and press INSERT or PLUS SIGN key.

    • Click the Filter Green button of the group you want to enhance.

  3. Click the condition column and select the column you need from the appeared menu.

  4. Click the condition criteria operator and select the the criteria operator you want to apply.

  5. If the condition operator requires operand values, specify them.