Skip to main content

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

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

Like Selects records that match the entered pattern. Use the _ and % wildcards to omit one or multiple irrelevant characters.

Equals

Equals Selects records that are equal to the entered value.

Contains

Contains Selects records that contain the entered string.

BeginsWith

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

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

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

DoesNotEqual Selects records that do not equal the entered value. Opposite to the Equals clause.

Greater

Greater Selects records that are greater than the entered value. String values are compared according to their alphabetical order.

GreaterOrEqual

GreaterOrEqual Selects records that are greater than the entered value or equal to it. String values are compared according to their alphabetical order.

Less

Less Selects records that are less than the entered value. String values are compared according to their alphabetical order.

LessOrEqual

LessOrEqual Selects records that are less than the entered value or equal to it. String values are compared according to their alphabetical order.

NotLike

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.

Related API Members

The following properties accept/return AutoFilterCondition values:

See Also