Predefined Filters

Nov 13, 2024

Filter Elements allow end users to create complex filters. If you are working with DevExpress v18.2 , you can also enable Predefined Filters.

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:

Xaml

xaml

<Window ...
        xmlns:dxfui="http://schemas.devexpress.com/winfx/2008/xaml/core/filteringui">

<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 &lt; 25" Name="From 15 to 25" />
              <dxfui:PredefinedFilter Filter="?p &lt; 15" Name="Less than 15" />
          </dxfui:PredefinedFilterCollection>
      </dxg:GridColumn.PredefinedFilters>
  </dxg:GridColumn>
</dxg:GridControl>

Apply Predefined Filters

Predefined Filters Element

You can show predefined filters in the PredefinedFiltersElement:

Xaml

xaml

<dxg:GridControl x:Name="grid" ... />
<!-- ... -->
<dxfui:PredefinedFiltersElement Context="{Binding FilteringContext, ElementName=grid}" FieldName="MPGCity" />

Filter Editor

You can select predefined filters in the Filter Editor:

Excel-style Drop-down Filter

You can select predefined filters in the Excel-style Drop-down Filter: