Filter Data in Vertical Grid
Overview
Filtering allows you to display a subset of records that meet certain criteria in the data source. When filtering is applied to ASPxVerticalGrid, only records that meet the specified criteria are displayed. Data can be filtered against a single row or multiple rows.
ASPxVerticalGrid allows its data to be filtered by row values or display text. This is controlled by the row’s GridDataColumnSettings.FilterMode property. Filtering by display text is ignored in database server mode.
End-users can build simple filter criteria, and apply it using the Header Filter of a row.
End-users can select the filter condition using the context menu, which is invoked by clicking the header filter button. 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 (‘%’, ‘_’)
Complex filter expressions can be applied in code or by using the filter control, which can be invoked by clicking the filter image or filter expression within the Filter Bar. The visibility of the filter bar is controlled by the ASPxGridSettings.ShowFilterBar option.