Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Filter Editor

  • 2 minutes to read

The Filter Editor dialog allows users to build complex filter criteria combined from multiple expressions.

The default filter editor type in v18.1 and higher is the Advanced Filter Editor. It supports syntax highlighting and autocomplete to facilitate user input.

To invoke this dialog, users can do one of the following:

  • Click Edit Filter in the Filter Panel.
  • Right-click a column header and select Filter Editor.

The Filter Editor can present filters as visual blocks and as text. You can choose one type or enable two tabs with both types.

DevExpress WinForms Data Grid Advanced Filter Editor VisualAndText filter representation

#Configure the Filter Editor

#Common Settings

The table below lists the main properties that affect the Filter Editor’s appearance and behavior.

API

Description

ColumnViewOptionsFilter.AllowFilterEditor

Gets or sets whether the Filter Editor is available.

ColumnViewOptionsFilter.DefaultFilterEditorView

Gets or sets how an end user can edit expressions in the Filter Editor.

ColumnViewOptionsFilter.FilterEditorAggregateEditing

Gets or sets whether filters can be created against properties that are List objects.

ColumnView.FilterEditorCreated

Handle this event to access the Filter Control and configure its additional settings.

The following settings do not apply to the Advanced Filter Editor.

WindowsFormsSettings.UseAdvancedFilterEditorControl

Disable this property in v18.1 and higher to use the Filter Editor.

ColumnViewOptionsFilter.UseNewCustomFilterDialog

Enable this property to allow users to filter values of a GridColumn not only against a constant value, but also against values of other GridColumns when the Custom drop-down item is clicked.

ColumnView.CustomFilterDialog

Handle this event to alter the default behavior when users click the Custom item in a classic filter drop-down menu. Refer to the following help topic for more information: Advanced Filter and Search Concepts.

See Also