OptionsColumnFilter.AutoFilterCondition Property

Gets or sets the type of the comparison operator used to create filter conditions for the current column via the Automatic Filtering Row.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v23.2.dll

NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation

Declaration

C#

[XtraSerializableProperty]
[XtraSerializablePropertyId(3)]
public virtual AutoFilterCondition AutoFilterCondition { get; set; }

VB.NET

<XtraSerializableProperty>
<XtraSerializablePropertyId(3)>
Public Overridable Property AutoFilterCondition As AutoFilterCondition

Property Value

Type	Description
AutoFilterCondition	An AutoFilterCondition value that determines the type of the comparison operator used to create filter conditions for the current column via the auto filter row.

Available values:

Show 13 items

Name	Description
Default	The default condition depends on the column editor and column data type. For columns that use a text editor and contain strings (or display strings instead of actual non-string values and are filtered by these strings (see FilterMode)), this option enables the Contains condition. For all other columns, it enables the Equals condition.
Like	Selects records that match the entered pattern. Use the _ and % wildcards to omit one or multiple irrelevant characters.
Equals	Selects records that are equal to the entered value.
Contains	Selects records that contain the entered string.
BeginsWith	Selects records that start with the entered string. Equals to the Like clause with the % wildcard after the entered string. For example, the [Name] BeginsWith 'A' and [Name] Like 'A%' filter expressions are equal.
EndsWith	Selects records that end with the entered string. Equivalent to the Like clause with the % wildcard before the entered string. For example, the [Name] EndsWith 'A' and [Name] Like '%A' filter expressions are equal.
DoesNotContain	Selects records that do not contain the entered string. Equivalent to the NotLike clause with the % wildcard before and after the searched string. For example, the [Name] DoesNotContain 'AA' and [Name] NotLike '%AA%' filter expressions are equal.
DoesNotEqual	Selects records that do not equal the entered value. Opposite to the Equals clause.
Greater	Selects records that are greater than the entered value. String values are compared according to their alphabetical order.
GreaterOrEqual	Selects records that are greater than the entered value or equal to it. String values are compared according to their alphabetical order.
Less	Selects records that are less than the entered value. String values are compared according to their alphabetical order.
LessOrEqual	Selects records that are less than the entered value or equal to it. String values are compared according to their alphabetical order.
NotLike	Selects records that do not match the entered pattern. Opposite to the NotLike clause. For example, the [Name] Like 'J%y' filter expression returns January and July for a month list. The [Name] Not Like 'J%y' expression returns all months except January and July.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AutoFilterCondition
GridColumn	.OptionsFilter .AutoFilterCondition

Remarks

When an end-user types text within the Automatic Filtering Row‘s cell, a filter condition is created based upon the text entered. This filter is then applied to the View. The comparison operator used in this filter condition is determined by the column’s AutoFilterCondition property.

See the AutoFilterCondition enumeration topic for information on the available types of operators.

The GridOptionsFilter.AllowAutoFilterConditionChange property controls whether end-users can change filter conditions in the auto filter row at runtime.

Example

In the following sample the AllowAutoFilterConditionChange property is disabled, Data Grid uses a default auto filter condition to filter records. The AutoFilterCondition property changes this default condition for the “Company Name” column from “Contains” to “Starts With”.

C#

gridView1.OptionsView.ShowAutoFilterRow = true;
gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False;
colCompanyName.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.BeginsWith;

VB.NET

gridView1.OptionsView.ShowAutoFilterRow = True
gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False
colCompanyName.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.BeginsWith