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
Use the BaseColumn.PredefinedFilters property to specify predefined filters:
<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 smart Excel-style Drop-down Filter: