Lists the comparison operator types for the filter conditions created for specific columns via the auto-filter panel.
The Like comparison operator selects records whose values in the corresponding column start with the entered string.
The Equals comparison operator selects records whose values in the corresponding column match the entered value.
The Contains operator selects records whose values in the corresponding column contain the entered string.
For text and number columns as well as for date columns being filtered by their display text (the GridColumn.ColumnFilterMode property is set to ColumnFilterMode.DisplayText), the Like comparison operator is used as the default to create filter conditions. For other columns, the Equals comparison operator is used.
Related API Members
The following properties accept/return AutoFilterCondition values:
The auto-filter panel allows end-users to filter data on the fly. Typing text within this panel's cell automatically creates a filter condition against the corresponding column. The comparison operator used in this condition is determined by the column's GridColumn.AutoFilterCondition property.