Predefined Filters
The Filtering UI allows end users to create complex filters, but starting from v18.2, you can provide Predefined Filters out of the box.
How to Specify Predefined Filters
- Create a PredefinedFilter and specify its PredefinedFilter.Name and PredefinedFilter.Filter properties.
- Add the predefined filter to the PredefinedFilterCollection and specify the ColumnBase.PredefinedFilters property.
The following code sample shows how to specify predefined filters for the MPGCity column:
<dxg:GridControl Name="grid">
<!-- -->
<dxg:GridColumn FieldName="MPGCity">
<dxg:GridColumn.PredefinedFilters>
<dxfui:PredefinedFilterCollection>
<dxfui:PredefinedFilter Filter="?p >= 25" Name="More than 25" />
<dxfui:PredefinedFilter Filter="?p >= 15 AND ?p < 25" Name="From 15 to 25" />
<dxfui:PredefinedFilter Filter="?p < 15" Name="Less than 15" />
</dxfui:PredefinedFilterCollection>
</dxg:GridColumn.PredefinedFilters>
</dxg:GridColumn>
</dxg:GridControl>
How to Use Predefined Filters
Predefined Filters Element
You can show predefined filters in the PredefinedFiltersElement:
Filter Editor
You can select predefined filters in the new Filter Editor:
Excel-style Drop-down Filter
You can select predefined filters in the Excel-style Drop-down Filter:
To enable Excel-style Drop-down Filter:
- For a specific column, set the ColumnBase.FilterPopupMode property to FilterPopupMode.ExcelSmart.
- For all columns, set the DataViewBase.ColumnFilterPopupMode to ColumnFilterPopupMode.ExcelSmart.