windowsforms-devexpress-dot-xtragrid-dot-columns-bba5bfea.md
Enumerates comparison operators used in the Auto-Filter Row.
Namespace : DevExpress.XtraGrid.Columns
Assembly : DevExpress.XtraGrid.v25.2.dll
NuGet Packages : DevExpress.Win.Grid, DevExpress.Win.Navigation
public enum AutoFilterCondition
Public Enum AutoFilterCondition
| 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.
|
The following properties accept/return AutoFilterCondition values:
See Also