Filter Data

• Jan 26, 2023
• 2 minutes to read

Read Tutorial: Filter Data in Code

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: