Filter Elements

• Feb 25, 2020
• 3 minutes to read

You can use Filter Elements to filter the GridControl / TreeListControl‘s data. Filter Elements are separate controls within your application that automatically retrieve available values, format settings, and other information from the bound control.

Using Filter Elements, you can build your own UI to filter control data. As an example, here is a UI that uses Filter Elements for a filtering panel displayed next to the GridControl:

Tip

Demo: Filtering UI

Requires installation of WPF Subscription. Download

Create a Filter Element

1. Add a filter element (the FilterElement class descendants) to the markup.
2. Set the attached FilterElement.Context property to associate the filter element with the GridControl‘s filter context.
3. Specify the field name of the column you want to filter using the FilterElement.FieldName property.

The following code sample uses the CheckedListFilterElement to filter the GridControl‘s data by the City column values:

Xaml

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

The image below shows the result:

Filter Element Types

Tip

Demo: Filtering

Requires installation of WPF Subscription. Download

Filter Element	Image	Description
CheckBoxFilterElement		Allows a user to filter by boolean values. <dxfui:CheckBoxFilterElement FieldName="HasAttachment" />
RadioListFilterElement		Allows a user to select one filter value from a set. <dxfui:RadioListFilterElement FieldName="Doors" />
CheckedListFilterElement		Allows a user to select multiple filter values from a set. <dxfui:CheckedListFilterElement FieldName="TrademarkID" /> SelectAllWhenFilterIsNull - Gets or sets whether to select all filter values when the filter is null.
CheckedTreeListFilterElement		Allows a user to filter by hierarchical values. <dxfui:CheckedTreeListFilterElement FieldName="SalesDate" /> DateTimeFilterTreeType - Gets or sets the date-time filter tree type. ImplyEmptyStringLikeBlank - Gets or sets whether to imply that empty strings are blank. SelectAllWhenFilterIsNull - Gets or sets whether to select all filter values when the filter is null. ShowSearchPanel - Gets or sets whether to show the search panel. StringFilterTreeType - Gets or sets the string filter tree type.
PredefinedFiltersElement		Allows a user to apply a column’s Predefined Filters. Use the ColumnBase.PredefinedFilters property to specify predefined filters. <dxfui:PredefinedFiltersElement FieldName="MPGCity" />
FormatConditionFilterElement		Allows a user to apply a column’s Conditional Formatting Filters. Use the TableView.FormatConditions / TreeListView.FormatConditions property to define conditional formatting rules. <dxfui:FormatConditionFilterElement FieldName="UnitPrice"/>
RangeFilterElement		Allows a user to filter by numeric values. <dxfui:RangeFilterElement FieldName="Price" />
DateRangeFilterElement		Allows a user to specify a date interval. <dxfui:DateRangeFilterElement FieldName="SalesDate" />
CalendarFilterElement		Allows a user to filter by date values. <dxfui:CalendarFilterElement FieldName="SalesDate" />
DatePeriodsFilterElement		Allows a user to apply predefined date filters. <dxfui:DatePeriodsFilterElement FieldName="SalesDate" />
MultiFilterElement		Allows a user to choose filter conditions. <dxfui:MultiFilterElement FieldName="SalesDate" />
ExcelStyleFilterElement		Consists of two tabs. The first tab allows a user to apply filter conditions. The second tab provides an Excel-style checklist. <dxfui:ExcelStyleFilterElement FieldName="Employee" /> AllowedFilterTypes - Gets or sets the allowed tabs displayed within the Excel-style filter element. DefaultFilterType - Gets or sets the default tab (Rules or Values) displayed within the excel-style filter element. FilterRulesTemplate - Gets or sets the Rules tab template. FilterValuesTemplate - Gets or sets the Values tab template. QueryOperators - Allows you to customize operators in the Excel-style Filter Element.

Limitations

• In Virtual Sources and Server Mode, record counts are not displayed by default. To display record counts, handle the DataControlBase.CustomUniqueValues event. For Virtual Sources, you can alternatively handle the GetUniqueValues event.

• In Virtual Sources and Server Mode, the RangeFilterElement and DateRangeFilterElement are not supported.