Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Data Binding
   [Expand]Views
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Sorting
   [Expand]Filter and Search
   [Expand]Summaries
   [Expand]Focus and Selection Handling
    Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
    Split Presentation
    Row Preview Sections
    Scrolling
   [Expand]Batch Modifications
   [Expand]Hit Information
    Hints
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Collapse]End-User Capabilities
     End-User Capabilities: Data Editing
     End-User Capabilities: Locating Rows Using Incremental Search
     End-User Capabilities: Controlling the Visibility of Columns, Bands and Card Fields
     End-User Capabilities: Navigating Through Rows and Cells
     End-User Capabilities: Rearranging Columns, Bands and Card Fields
     End-User Capabilities: Resizing Columns and Bands
     End-User Capabilities: Resizing Cards
     End-User Capabilities: Selecting Rows/Cards
     End-User Capabilities: Expanding and Collapsing Rows and Cards
     End-User Capabilities: Sorting
     End-User Capabilities: Grouping
     End-User Capabilities: Filtering
     End-User Capabilities: Filter Editor
     End-User Capabilities: Filter Editor - Building Filter Criteria
     End-User Capabilities: Applying Summaries
     End-User Capabilities: Locating Rows Using Search (Find) Panel
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[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

End-User Capabilities: Filter Editor

Expanded Filter Editor

The filter editor is used to edit filter criteria for a grid control. To create and customize filter criteria, use the and buttons embedded into the control and context menus supported by editor elements:.

Remarks

A filter condition group is a set of conditions combined by the same logical operator. The following filter expression contains two groups combined by the logical OR operator: "([Product] = 'Chang' And [Quantity] > 20) Or ([Product] In ('Tofu', 'Konbu') And [Quantity] < 100)". In the Filter Editor it is represented as follows.

For step-by-step examples of creating filter criteria, see End-User Capabilities: Filter Editor - Building Filter Criteria.

Expanded Add Conditions

To add a condition to a logical group, do one of the following.

  • Focus any condition within the group or the group's logical operator, and then press INSERT or ADD on the keyboard.
  • Click the button for the group.
  • Click the group's logical operator and select Add Condition.

To add a group of conditions to another group, do one of the following.

  • Focus any condition within the group or the group's logical operator, and then press CTRL+ADD on the keyboard.
  • Click the group's logical operator and select Add Group.

To add a condition or a group of conditions that have been copied to the Clipboard, press CTRL+V or SHIFT+INSERT. The new condition will be added to the focused group.

Expanded Delete Conditions

To delete a condition, do one of the following.

  • Focus the condition and press DELETE or SUBTRACT.
  • Click the button.

To delete a group of conditions, do one of the following.

  • Focus the group's logical operator and press DELETE or SUBTRACT
  • Click the group's logical operator and select Remove Group.

To delete all conditions, do one of the following.

  • Focus the topmost logical operator and press DELETE or SUBTRACT.
  • Click the topmost logical operator and select Clear All.

To cut a condition/group of conditions to the Clipboard, focus this condition/the group's logical operator and press CTRL+X or SHIFT+DELETE.

Expanded Work with Clipboard

To copy a condition/group of conditions to the Clipboard, focus this condition/the group's logical operator and press CTRL+C or CTRL+INSERT.

To cut a condition/group of conditions to the Clipboard, focus this condition/the group's logical operator and press CTRL+X or SHIFT+DELETE.

To paste a condition/group of conditions from the Clipboard to the focused group, press CTRL+V or SHIFT+INSERT.

Expanded Change a Column in a Filter Condition

To change a condition's column, invoke the column list by doing one of the following.

  • Click the current column.
  • Focus the current column via the keyboard and press SPACE or ALT+DOWN ARROW.

Then, choose the required column from the list to be invoked

Expanded Change an Operator in a Filter Condition

To change a condition's operator, invoke the operator list by doing one of the following.

  • Click the condition's current operator.
  • Focus the current operator via the keyboard and press SPACE or ALT+DOWN ARROW

Then, choose the required operator from the list to be invoked

Expanded Edit a Condition's Value

To edit a condition's value, click the operand value and type text.

To activate the operand value's edit box without changing the value, click the value or focus the operand value via the keyboard and press F2, SPACE, ENTER or ALT+DOWN

To close the active edit box, press ENTER.

To discard changes to the value and close the active edit box, press ESC.

Expanded Compare a Condition's Column with Another Column

Do one of the following:

  • Click the toggle button:

  • Press CTRL+Q
Then, specify the column via the operand value's edit box.
Note

This feature is not supported by default. It must be enabled by setting the ColumnViewOptionsFilter.UseNewCustomFilterDialog property to true.

Note

This feature is supported by a limited set of operators: =, <>, >, <, >=, <=. Like, Not Like, Between, Not Between, Any Of and None Of.

Expanded Navigation

To focus a specific filter condition or a group's operator within the Filter Editor, do one of the following.

  • Click the target element.
  • Use Arrow keys to move focus via the keyboard.

Expanded Invoke the Filter Editor

To invoke the Filter Editor do one of the following:

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

  • If the filter panel at the bottom of the grid control is visible, click the Edit Filter button.

The Filter Editor is also invoked when choosing the (Custom...) item in a column's filter dropdown list, if the current filter criteria applied to the column consists of three or more simple filter conditions, or if the filter criteria contain advanced comparison operators such as "Is between" and "Is any of".

Expanded See Also

How would you rate this topic?​​​​​​​