Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[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
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   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
     Filtering Overview
     Automatic Filter Row
     Filter Dropdown
     Filter Editor
     Filter Modes and Custom Filtering
     Filtering in Code
     Filter Expressions
     Search Panel
     Incremental Search
     Filtering Nodes
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Data 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]Diagram Control
  [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]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Filter Editor

The Filter Editor allows end-users to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators.

Note

The Filter Editor is not intended to be used in Windows Forms hosted applications.

Expanded Filter Editor's Settings

The availability of the Filter Editor is controlled by the DataViewBase.AllowFilterEditor option. By default, this property is set to true, allowing end-users to use the Filter Editor. End-users can invoke the Filter Editor using the button, which is displayed within the Filter Panel or via the Column Header Context Menu.

In code, the Filter Editor can be opened via the DataViewBase.ShowFilterEditor method. To customize the Fillter Editor before it is displayed, handle the DataViewBase.FilterEditorCreated event.

The Filter Editor's UI can be localized. For details on localizing DevExpress WPF products, see Localization.

Expanded Filter Editor's UI

The Filter Editor displays filter criteria as a tree structure, where nodes represent simple filter conditions. If the filter criteria consist of multiple filter conditions, the Filter Editor contains multiple nodes linked by logical operators into groups. For instance, the following image shows the Filter Editor representing the "[Product] = 'Chang' And [Quantity] > 20" filter expression:

Conditions combined by a logical operator at the same level form a group. You can think of groups as clauses wrapped by round brackets in the filter expression. There is only one group in the example above. In the following example, the filter expression contains two groups combined by the logical OR operator. The expression "([Product] = 'Chang' And [Quantity] > 20) Or ([Product] In ('Tofu', 'Konbu') And [Quantity] < 100)" is represented in the Filter Editor as follows:

The image below shows the Filter Editor, indicating its UI elements.

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