Filter Data

• Jul 23, 2020
• 2 minutes to read

Drop-down Filter

The drop-down filter displays the column’s unique values. Click the column’s Filter Button to invoke the column’s drop-down filter, and select values from the Filter Values tab:

The Filter Rules tab contains criteria operators that allow end users to create a column’s filter:

Automatic Filter Row

End users can type text into the Automatic Filter Row to filter data against the entered values:

To show the Automatic Filter Row, set the TableView.ShowAutoFilterRow property to true.

To allow end users to choose a criteria type in the Automatic Filter Row, set the TableView.ShowCriteriaInAutoFilterRow property to true.

Filter Editor

To invoke the Filter Editor, select the Filter Editor item of a column header’s context menu:

The Filter Editor allows end users to build filter criteria. Filter criteria consist of conditions. To create a condition, specify a column name, criteria operator, and operand value. To combine conditions, specify a logical operator.

Clear Filter

To clear a column’s filter:

• Invoke the column’s Drop-down Filter and click (All).

  

• Right-click a column’s header and select Clear Filter:

  

To clear all filters, click the Filter Panel‘s Close Filter button:

Disable Filter

To disable a filter, uncheck the Filter Panel‘s Enable Filter box:

Search Panel

To display the Search Panel, do one of the following:

• Press CTRL+F.
• Click the Show Search Panel button ().

• Right-click a column’s header and select Show Search Panel:

  

Specify a search string in the Search Panel‘s edit box to filter the GridControl‘s data: