All docs
V20.2
20.2
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

Data Filtering and Search

The GridControl, VGridControl, PivotGridControl, PropertyGridControl, TreeList, GanttControl, and ChartControl allow you to filter and search for data. When you filter data, the control only displays records that meet the applied filter criteria. When you search for data, however, the control only highlights records. Users can utilize the following features to filter and search for data:

The following comparison table lists features supported by DevExpress data-aware controls.

Control

Excel-Style Filter Menus

Classic Filter Menus

Auto-Filter Row

Filter Panel & Filter Editor

Find Panel

Filter UI Context

Incremental Search

Filter in Code

GridControl

yes

yes

yes

yes

yes

yes

yes

yes

TreeList, GanttControl

yes

yes

yes

yes

yes

yes

yes

yes

PivotGridControl

yes

yes

yes

yes

yes

yes

yes

yes

VGridControl

yes

no

no

yes

yes

yes

no

yes

PropertyGridControl

no

no

no

no

yes

no

no

yes

ChartControl

no

no

no

no

no

yes

no

yes

TIP

Data controls with similar features expose the same API. For example, to access options specific to Excel-style filter menus, you can use the GridView.OptionsFilter, VGridControl.OptionsFilter, PivotGridControl.OptionsFilter or TreeList.OptionsFilter property.