ColumnBase.AutoFilterCondition Property

Gets or sets the type of the comparison operator used to create filter conditions for the current column using the Automatic Filter Row. This is a dependency property.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v24.2.Core.dll

NuGet Package: DevExpress.Wpf.Grid.Core

Declaration

C#

[Browsable(false)]
public AutoFilterCondition AutoFilterCondition { get; set; }

VB.NET

<Browsable(False)>
Public Property AutoFilterCondition As AutoFilterCondition

Property Value

Type	Description
AutoFilterCondition	An AutoFilterCondition enumeration value that specifies the type of the comparison operator.

Available values:

Name	Description
Like	The Like comparison operator is used to create filter conditions. This operator selects records whose values in the corresponding column start with the entered string.
Equals	The Equals comparison operator is used to create filter conditions. This operator selects records whose values in the corresponding column match the entered value.
Contains	The Contains operator is used to create filter conditions. This operator selects records whose values in the corresponding column contain the entered string.
Default	For string values, the Like comparison operator is used to create filter conditions. This operator selects records whose values in the corresponding column start with the entered string. For other values (e.g. Boolean, numeric), the Equals comparison operator is used.

Remarks

Use the AutoFilterCondition property to specify the comparison operator type: CONTAINS, EQUALS, or LIKE. To learn more, see Automatic Filter Row and Filter Modes and Custom Filtering.

A cell’s filter criterion depends on the AutoFilterCondition and ColumnBase.AutoFilterCriteria properties:

• When the ColumnBase.AutoFilterCriteria property is not null, the Automatic Filter Row uses the criterion specified in this property.

• The Automatic Filter Row uses the ColumnBase.AutoFilterCriteria property and ignores the AutoFilterCondition property if the ColumnBase.ShowCriteriaInAutoFilterRow property is set to true.

  When the ColumnBase.AutoFilterCriteria property is null, the Automatic Filter Row chooses a filter criterion depending on the column type and the column filter mode (ColumnBase.ColumnFilterMode).

• The Automatic Filter Row uses the AutoFilterCondition when the ColumnBase.AutoFilterCriteria property is null.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the AutoFilterCondition property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

XAML

wpf-data-grid-use-automatic-filter-row-without-special-symbols/CS/AutoFilterlRow/MainWindow.xaml#L14

<dxg:GridControl.Columns>
    <dxg:GridColumn FieldName="Name" AutoFilterCondition="Like"/>
    <dxg:GridColumn FieldName="Value" AutoFilterCondition="Contains"/>