[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].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Data
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Collapse]DevExpress.Xpf.Core.FilteringUI
    AllowedExcelStyleFilterTypes Enumeration
   [Expand]BinaryFilterModel Class
   [Expand]CalendarFilterElement Class
   [Expand]CalendarFilterModel Class
   [Expand]CheckBoxFilterElement Class
   [Expand]CheckBoxFilterModel Class
   [Expand]CheckedListFilterElement Class
   [Expand]CheckedListFilterModel Class
   [Expand]CheckedTreeListFilterElement Class
   [Expand]CheckedTreeListFilterModel Class
   [Expand]ConstantFilterModel Class
   [Expand]CustomUniqueValuesEventArgs Class
   [Expand]CustomValueDisplayTextEventArgs Class
   [Expand]DatePeriodFilterValue Class
   [Expand]DatePeriodsFilterElement Class
   [Expand]DatePeriodsFilterModel Class
   [Expand]DateRangeFilterElement Class
   [Expand]DateRangeFilterModel Class
    DateTimeFilterTreeType Enumeration
   [Expand]ExcelStyleFilterElement Class
   [Expand]ExcelStyleFilterElementOperatorItem Class
   [Expand]ExcelStyleFilterElementOperatorItemList Class
    ExcelStyleFilterElementOperatorType Enumeration
   [Expand]ExcelStyleFilterElementQueryOperatorsEventArgs Class
   [Expand]ExcelStyleFilterModel Class
    ExcelStyleFilterType Enumeration
   [Expand]FieldItem Class
   [Expand]FieldList Class
   [Expand]FilterBehavior Class
   [Expand]FilterChangedEventArgs Class
   [Expand]FilterEditorCommands Class
   [Collapse]FilterEditorControl Class
     FilterEditorControl Members
     FilterEditorControl Constructor
    [Expand]FilterEditorControl Properties
    [Collapse]FilterEditorControl Events
      FilterChanged Event
      QueryConditionOperations Event
      QueryFields Event
      QueryGroupOperations Event
      QueryGroupTypes Event
      QueryOperators Event
    [Expand]FilterEditorControl Methods
   [Expand]FilterEditorOperatorItem Class
   [Expand]FilterEditorOperatorItemList Class
    FilterEditorOperatorType Enumeration
   [Expand]FilterEditorQueryOperatorsEventArgs Class
   [Expand]FilterElement Class
   [Expand]FilterField Class
   [Expand]FilterFieldCollection Class
   [Expand]FilteringUIContext Class
   [Expand]FilterModel Class
   [Expand]FilterModelBase Class
   [Expand]FilterModelValueItem Class
    FilterValuesSortMode Enumeration
   [Expand]FormatConditionFilterModel Class
   [Expand]MultiFilterElement Class
   [Expand]MultiFilterModel Class
   [Expand]OperatorItemBase Class
   [Expand]PredefinedFilter Class
   [Expand]PredefinedFilterCollection Class
   [Expand]PredefinedFiltersElement Class
   [Expand]PredefinedFiltersModel Class
    PropertySelectorMode Enumeration
   [Expand]QueryConditionOperationsEventArgs Class
   [Expand]QueryFieldsEventArgs Class
   [Expand]QueryGroupOperationsEventArgs Class
   [Expand]QueryGroupTypesEventArgs Class
   [Expand]QueryOperatorsEventArgsBase<T> Class
   [Expand]RadioListFilterElement Class
   [Expand]RadioListFilterModel Class
   [Expand]RangeFilterElement Class
   [Expand]RangeFilterModel Class
   [Expand]RangeFilterModelBase<T> Class
    StringFilterTreeType Enumeration
   [Expand]TernaryFilterModel Class
   [Expand]VariadicFilterModel Class
  [Expand]DevExpress.Xpf.Core.Native
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Dialogs
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DataPager
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Native
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gantt
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Common
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.iCalendar
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.Scheduling.VisualData
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Printing
[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)

FilterEditorControl.QueryOperators Event

Allows you to customize the operator list.

Namespace:DevExpress.Xpf.Core.FilteringUI
Assembly:DevExpress.Xpf.Grid.v19.2.dll

Expanded Syntax

Expanded Event Data

The event handler receives an argument of type FilterEditorQueryOperatorsEventArgs containing data related to this event.

The following FilterEditorQueryOperatorsEventArgs properties provide information specific to this event.
Property Description
DefaultOperator Gets or sets an operator that is selected when users create a new filter condition.
FieldName Gets a name of the field for which operators are queried.
Filter Gets the current filter criteria specified in the FilterEditorControl.
Operators Gets or sets the operators displayed in the operator list.

Expanded Remarks

Tip

Demo: Filter Editor - Customize the Operator List

Requires installation of WPF Subscription. Download

The Filter Editor shows a list of operators the selected field accepts. Use the QueryOperators event to customize the operator list.

The code sample below removes all operators except Equal and Not Equal:

Custom Operators

You can use the QueryOperators event to add custom operators. The code sample below adds the Last Years operator:

  1. Create a custom function. Do one of the following:

    • Use the CustomFunctionFactory.Create method.

      The CustomFunctionFactory is an extension of the DevExpress.Xpf.Grid.v19.2.Extensions.dll library. Refer to c:\Program Files (x86)\DevExpress 19.2\Components\Sources\DevExpress.Xpf.Grid\DevExpress.Xpf.Grid.Extensions\ for information on how extension methods work.

      The CustomFunctionFactory.Create method allows you to create a custom function with a maximum of 4 operands.

    • Implement the DevExpress.Data.Filtering.ICustomFunctionOperator interface. Refer to the Implementing Custom Functions topic for more information.

  2. Call the DevExpress.Data.Filtering.CriteriaOperator.RegisterCustomFunction method to register the custom function.

  3. Create the FilterEditorOperatorItem and add it to the FilterEditorQueryOperatorsEventArgs.Operators collection. Specify the operator item's edit settings (see BaseEditSettings) to define its operands:

Expanded See Also

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