AutoFilterCondition Enum

Enumerates the comparison operator types for the filter conditions created for specific columns via the automatic filtering row.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v20.1.dll

Declaration

public enum AutoFilterCondition
Public Enum AutoFilterCondition

Members

Name Description
Default

For columns being filtered by their display text (see GridColumn.FilterMode), the Default option acts identically to the Like option.

The Default option acts like the Equals option for the columns that have any of the following in-place editors or any of their descendants: CheckEdit, LookUpEditBase or ImageComboBoxEdit.

For other columns, the Default option acts identically to the Like option.

Like

The Like comparison operator selects records whose values in the corresponding column match the entered string. Use the "" and "%"_ wildcards to omit one or multiple irrelevant characters respectively.

For the columns that use CheckEdit, LookUpEditBase or ImageComboBoxEdit in-place editors, the Equals operator is always used, unless these columns are filtered by display text (see GridColumn.FilterMode).

Equals

The Equals comparison operator selects records whose values in the corresponding column match the entered value.

Contains

The Contains operator selects records whose values in the corresponding column contain the entered string.

BeginsWith

Selects records that start with the entered string. Equal to the AutoFilterCondition.Like clause with the "%" wildcard after the searched string.

For example, the [Name] BeginsWith 'A' and [Name] Like 'A%' filtering expressions are equal.

EndsWith

Selects records that end with the entered string. Equal to the AutoFilterCondition.Like clause with the "%" wildcard before the searched string.

For example, the [Name] EndsWith 'A' and [Name] Like '%A' filtering expressions are equal.

DoesNotContain

Selects records that do not contain the entered string. Equal to the AutoFilterCondition.NotLike clause with the "%" wildcard before and after the searched string.

For example, the [Name] DoesNotContain 'AA' and [Name] NotLike '%AA%' filtering expressions are equal.

DoesNotEqual

Selects records that do not equal the entered string. This clause acts as an opposite to the AutoFilterCondition.Equals clause.

Greater

Selects records that are greater than the entered value.

For text records, "greater" values are those that would lie below the entered value in an alphabetically sorted list. For example, in a list with Latin characters, all letters from "N" to "Z" are greater than the letter "M".

GreaterOrEqual

Selects records that are greater than the entered value or equal to it.

For text records, "greater" values are those that would lie below the entered value in an alphabetically sorted list. For example, in a list with Latin characters, all letters from "M" to "Z" are greater or equal to the letter "M".

Less

Selects records that are less than the entered value.

For text records, "less" values are those that would lie above the entered value in an alphabetically sorted list. For example, in a list with Latin characters, all letters from "A" to "L" are less than the letter "M".

LessOrEqual

Selects records that are less than the entered value or equal to it.

For text records, "less" values are those that would lie above the entered value in an alphabetically sorted list. For example, in a list with Latin characters, all letters from "A" to "L" are less than the letter "M".

NotLike

Selects records that do not match the entered string. Acts as an opposite to the AutoFilterCondition.Like clause.

For example, from a list with month names the [Name] Like 'J%y' filter expression will return the "January" and "July" records. The [Name] Not Like 'J%y' expression will return the names of remaining ten months.

Related API Members

The following properties accept/return AutoFilterCondition values:

Remarks

The automatic filtering row allows end-users to filter data on the fly. Typing text within the row's cell automatically creates a filter condition against the corresponding column. The comparison operator used in this condition is determined by the column's OptionsColumnFilter.AutoFilterCondition property of the AutoFilterCondition type. The values can be compared using the Equals or Like operators.

See Also