windowsforms-devexpress-dot-xtragrid-dot-columns-dot-optionscolumnfilter.md
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.v25.2.dll
NuGet Packages : DevExpress.Win.Grid, DevExpress.Win.Navigation
[XtraSerializableProperty]
[XtraSerializablePropertyId(3)]
public virtual AutoFilterCondition AutoFilterCondition { get; set; }
<XtraSerializableProperty>
<XtraSerializablePropertyId(3)>
Public Overridable Property AutoFilterCondition As AutoFilterCondition
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to AutoFilterCondition |
|---|---|
| GridColumn |
.OptionsFilter .AutoFilterCondition
|
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.
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”.
gridView1.OptionsView.ShowAutoFilterRow = true;
gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False;
colCompanyName.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.BeginsWith;
gridView1.OptionsView.ShowAutoFilterRow = True
gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False
colCompanyName.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.BeginsWith
See Also