Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Filter Data

  • 2 minutes to read

Read Tutorial: Filter Data in Code

The drop-down filter displays the column’s unique values. Click the column’s Filter Button (Show Drop-down 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: