GridColumn.AutoFilterCondition Property

Gets or sets the filter condition (equals, contains, etc.) used to compare the value in the Auto-Filter Row with column values. This is a bindable property.

Namespace: DevExpress.Maui.DataGrid

Assembly: DevExpress.Maui.DataGrid.dll

NuGet Package: DevExpress.Maui.DataGrid

Declaration

public DataFilterCondition AutoFilterCondition { get; set; }

Property Value

Type	Description
DataFilterCondition	The filter condition used to compare the value in the Auto-Filter Row with column values.

Available values:

Name	Description
Default	The filter condition depends on the type of the column.
StartsWith	Values in a column should start with the value in the Auto Filter Row.
Contains	Values in a column should contain the value in the Auto Filter Row.
Equals	Values in a column should equal the value in the Auto Filter Row.

Remarks

Enable the DataGridView.ShowAutoFilterRow option to display the auto filter row—a special row at the top of the grid that allows users to filter values in columns.

The auto filter row allows users to filter values in all columns. You can use a column’s AllowAutoFilter property to disable this feature for an individual column.

Filter Mode

The DataGridView can format data field values before they are displayed in grid cells. For example, you can use the TextColumn.Mask property to specify a mask that restricts the user input and formats the output. The GridColumn.FilterMode property specifies whether filters are applied to actual data field values or to text displayed in cells. The filter mode may affect the default filter condition. See AutoFilterCondition for more information.

Specify Filter Values and Conditions in Code

A column’s AutoFilterValue property specifies the cell value in the auto filter row. The specified value is used to create a filer criterion based on the default filter condition (equals, contains, etc.), which depends on the type of the column. To use a specific condition, you can set the column’s AutoFilterCondition property to one of the following values:

• Contains—values in the column should contain the criterion entered in the auto filter row.
• Equals—values in the column should be equal to the criterion entered in the auto filter row.
• Like—values in the column should start with the criterion entered in the auto filter row.

The ImmediateUpdateAutoFilter property specifies whether to filter data each time a value in the auto filter row is changed or only when a cell in the auto filter row loses focus.

The markup below enables the auto filter row in the grid, specifies the filter condition and initial filter for the first column, and prevents users from filtering values in the second column:

XAML

<dxg:DataGridView ItemsSource="{Binding Orders}"
                  ShowAutoFilterRow="True">
    <dxg:DataGridView.Columns>
        <dxg:TextColumn FieldName="Product.Name" Caption="Product" Width="150" 
                        AutoFilterCondition="Contains" AutoFilterValue="Ch"/>
        <dxg:NumberColumn FieldName="Product.UnitPrice" Caption="Price"
                          AllowAutoFilter="False"
                          DisplayFormat="C0" MinWidth="100"/>
        <dxg:NumberColumn FieldName="Quantity" MinWidth="100"/>
        <dxg:NumberColumn FieldName="Total" 
                          UnboundType="Integer" UnboundExpression="[Quantity] * [Product.UnitPrice]"
                          IsReadOnly="True" DisplayFormat="C0" MinWidth="100"/>
        <dxg:CheckBoxColumn FieldName="Shipped" MinWidth="100"/>
    </dxg:DataGridView.Columns>
</dxg:DataGridView>

The AutoFilterRowHandle property returns the handle of the auto filter row. You can use this handle to identify the row. For example, you can pass this handle to the SetCellValue or GetCellValue method to get or set a cell value in code.

Auto Filter Row Appearance

The following table lists properties that allow you to customize auto filter row appearance:

Property	Description
DataGridView.ShowFilterIcon GridColumn.ShowFilterIcon	Specify whether to show filter icons in cells of the auto filter row.
FilterIconColor	Specifies the color of filter icons displayed in cells of the auto filter row.
AutoFilterRowHeight	Specifies the height of the auto filter row.