Filter Data
- 2 minutes to read
Overview
The filter feature allows you to display a subset of records that meet certain criteria in the data source. When a filter is applied to ASPxGridView, only data rows that meet the specified criteria are displayed. You can filter data against a single data column or multiple data columns.
You can filter ASPxGridView data by column values or display text. This is controlled by the column’s GridDataColumnSettings.FilterMode property. The filter-by-display-text feature is ignored in database server mode.
Users can build simple filter criteria, and apply it using the Filter Row or the Header Filter of a column.
The comparison operator used in a filter condition is determined by a column’s GridViewDataColumnSettings.AutoFilterCondition property. Users can click a column’s filter row button to invoke a context menu and select a filter condition from this menu. The following eleven operators are available:
- Begins with
- Contains
- Doesn’t contain
- Ends with
- Equals
- Is greater than
- Is greater than or equal to
- Is less than
- Is less than or equal to
- Doesn’t equal
- Like (‘%’, ‘_’)
You can apply complex filter expressions in code or by using the Filter control, which can be invoked from the filter bar. The ASPxGridSettings.ShowFilterBar option controls the filter bar’s visibility.