[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
     Filtering Overview
     Automatic Filter Row
     Filter Dropdown
     Filter Editor
     Filtering in Code
     Filter Expressions
     Allowed Filters
     Filter Modes and Custom Filtering
     Filtering Nodes
     Search Panel
     Incremental 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]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]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. End-users can add an unlimited number of filter conditions and groups them by logical operators.

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

Note

You can not use the Filter Editor in Windows Forms hosted applications.

Expanded Invoke the Filter Editor

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

  • Right click the required column header and select the Filter Editor... menu item.

  • Click the button in the Filter Panel.

You can open the Filter Editor in code with the DataViewBase.ShowFilterEditor method. Handle the DataViewBase.FilterEditorCreated event to customize the Filter Editor before it is displayed.

Expanded Filter Editor's UI

The Filter Editor displays filter criteria as a tree structure, where nodes are simple filter conditions. The Filter Editor groups filter conditions by logical operators if the filter criteria consist of several filter conditions. The following image displays the Filter Editor with 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 following image displays the "([Product] = 'Chang' And [Quantity] > 20) Or ([Product] In ('Tofu', 'Konbu') And [Quantity] < 100)" expression:

The image below shows the Filter Editor's UI elements.

Note

The Filter Editor's UI supports localization. See the Localization topic to learn more about.

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