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

Automatic Filter Row

A user can type text in the Automatic Filter Row to apply a filter condition to data.

Automatic Filter Row

Set the ColumnBase.ShowCriteriaInAutoFilterRow property to true to enable the filter criteria selector. The filter criteria selector allows users to choose filter criteria from the drop-down list.

Automatic Filter Row - Criteria Selector

 

The table below lists the main properties that affect elements’ behavior and appearance.

Characteristics Members
Visibility TableView.ShowAutoFilterRow
Position TableView.AutoFilterRowPosition
Availability and Behavior ColumnBase.AllowAutoFilter, ColumnBase.ImmediateUpdateAutoFilter, DataViewBase.FilterRowDelay
Criteria Selector Availability ColumnBase.ShowCriteriaInAutoFilterRow, TableView.ShowCriteriaInAutoFilterRow, TreeListView.ShowCriteriaInAutoFilterRow
Conditions and Criteria ColumnBase.AutoFilterCondition, ColumnBase.AutoFilterCriteria
Row Data ColumnBase.AutoFilterValue
Template ColumnBase.AutoFilterRowDisplayTemplate, ColumnBase.AutoFilterRowEditTemplate
Style ColumnBase.AutoFilterRowCellStyle, TableView.AutoFilterRowCellStyle

The EditSettings property affects the Automatic Filter Row. Specify the CellTemplate to assign a different editor for data cells:

 <dxg:GridColumn FieldName="Date">
    <!-- Automatic Filter Row uses TextEdit -->
    <dxg:GridColumn.EditSettings>
        <dxe:TextEditSettings/>
    </dxg:GridColumn.EditSettings>
    <!-- Data cells use DateEdit -->
    <dxg:GridColumn.CellTemplate>
        <DataTemplate>
            <dxe:DateEdit x:Name="PART_Editor"/>
        </DataTemplate>
    </dxg:GridColumn.CellTemplate>
</dxg:GridColumn>
See Also