[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Expand]Binding to Data
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Selection
   [Collapse]Filtering and Searching
    [Expand]Drop-down Filter
     Automatic Filter Row
     Filter Editor
     Filter Elements
    [Expand]Filtering in Code
    [Expand]Search
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus and Navigation
   [Expand]Conditional Formatting
   [Expand]Drag-and-Drop
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Filter Editor

The Filter Editor allows end users to build filter criteria. End users can add an unlimited number of filter conditions and use logical operators to group them.

Set the DataViewBase.AllowFilterEditor property to true to allow end users to invoke the Filter Editor.

Note

Expanded Invoke the Filter Editor

End users can invoke the Filter Editor in the following ways:

  • Right-click the column's header and select Filter Editor...:

In code, call the DataViewBase.ShowFilterEditor method to invoke the Filter Editor. You can handle the DataViewBase.FilterEditorCreated event to customize the Filter Editor before it is displayed.

Expanded Filter Editor UI

The Filter Editor displays filter criteria as a tree structure where nodes are filter conditions. The Filter Editor groups filter conditions by logical operators if the filter criteria consist of several filter conditions.

Example 1

The following image displays the Filter Editor with the "[Product] = 'Chang' And [Quantity] > 20" filter expression:

Example 2

The image below displays the Filter Editor with the "([Product] = 'Chang' And [Quantity] > 20) Or ([Product] In ('Tofu', 'Konbu') And [Quantity] < 100)" filter expression:

The filter expression contains two groups combined by the logical Or operator. You can consider groups as clauses wrapped by round brackets in the filter expression.

Filter Editor Elements

The image below describes the Filter Editor's elements:

Tip

The Filter Editor supports localization. Refer to the Localization topic for more information.

Expanded Allowed Group Filters

You can use the DataViewBase.AllowedGroupFilters property to specify the allowed group filters.

Example 1

The Filter Editor does not allow you to add groups. You can add only one node in the root group:

Example 2

You can add only groups with the specified type:

Note

  • The Filter Editor allows you to select only criteria operators that are available for the current column.
  • The Filter Editor allows you to select only columns that have allowed operators.

Refer to the Allowed Filters topic for information on how to specify these filters.

Is this topic helpful?​​​​​​​