AutoFilterCondition Enum

Enumerates comparison operators used in the Auto-Filter Row.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v24.1.dll

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

Declaration

C#
VB.NET

public enum AutoFilterCondition

Public Enum AutoFilterCondition

Members

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.