Filtering

• May 31, 2019
• 2 minutes to read

GridControl / TreeListControl

The GridControl and TreeListControl provide the following features to allow users to filter its data:

• Drop-down Filters
• Filter Editor
• Filter Elements
• Automatic Filter Row

Tip

Demo: Filtering in the GridControl | Filtering in the TreeListControl

Requires a WPF Subscription. Download

PivotGridControl

The PivotGridControl provides the following features to allow users to filter its data:

• Drop-down Filters
• Filter Editor
• Filter Elements

Tip

Demo: Excel Style Filtering

Requires a WPF Subscription. Download

Other Data-bound Controls

If a data-bound control does not provide a filtering UI (for example, Charts and Data Editors), you can use the FilterBehavior to allow the Filter Editor / Filter Elements to filter the control’s data:

1. Add the FilterBehavior to the behaviors of the Filter Editor / Filter Elements or a container that holds them. The FilterBehavior automatically specifies the FilterEditorControl.Context / FilterElement.Context properties.
2. Specify the FilterBehavior.ItemsSource property to allow the Filter Editor / Filter Elements to get unique filter values.
3. Specify the FilterBehavior.Fields property to configure display fields, edit settings, and predefined filters.

4. The FilterBehavior creates the FilterBehavior.ActualFilterCriteria object. Do one of the following:

   • Bind a data-bound control’s filter criteria to the FilterBehavior.ActualFilterCriteria object.
   • Use the FilterBehavior.ActualFilterCriteria object to filter data in code.

Tip

Topic: FilterBehavior

The following code sample shows how to use the FilterBehavior to allow the Filter Elements to work with the ListBoxEdit.

Xaml

<dxe:ListBoxEdit Name="listBoxEdit" ItemsSource="{Binding Products}"
                 FilterCriteria="{Binding ElementName=filterBehavior, Path=ActualFilterCriteria}"/>

<!-- -->    

<dxfui:CheckedListFilterElement FieldName="CategoryName">
    <dxmvvm:Interaction.Behaviors>
        <dxfui:FilterBehavior x:Name="filterBehavior" 
                              ItemsSource="{Binding ElementName=listBoxEdit, Path=ItemsSource}">
            <dxfui:FilterField FieldName="CategoryName">
                <dxe:ComboBoxEditSettings ItemsSource="{Binding Categories}"/>
            </dxfui:FilterField>
        </dxfui:FilterBehavior>
    </dxmvvm:Interaction.Behaviors>
</dxfui:CheckedListFilterElement>

Tip

Demo: FilterBehavior

Requires a WPF Subscription. Download