[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
    AllowedDataAnalysisFilters Enumeration
    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
   [Collapse]ExcelStyleFilterElement Class
     ExcelStyleFilterElement Members
     ExcelStyleFilterElement Constructor
    [Expand]ExcelStyleFilterElement Properties
    [Collapse]ExcelStyleFilterElement Events
      QueryOperators Event
   [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
   [Expand]FilterEditorControl Class
   [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]FormatConditionFilterElement Class
   [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)

ExcelStyleFilterElement.QueryOperators Event

Allows you to customize operators in the Excel-style Filter Element.

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 ExcelStyleFilterElementQueryOperatorsEventArgs containing data related to this event.

The following ExcelStyleFilterElementQueryOperatorsEventArgs 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.
Operators Gets or sets operators displayed in the operator list.

Expanded Remarks

Tip

Demo: Excel-style Drop-down Filter - Customize the Operator List

Requires installation of WPF Subscription. Download

The Excel-style Filter Element 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 ExcelStyleFilterElementOperatorItem and add it to the ExcelStyleFilterElementQueryOperatorsEventArgs.Operators collection. Specify the operator item's edit settings (see BaseEditSettings) to define its operands:

Expanded See Also

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