ExcelStyleFilterElement.QueryOperators Event

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

Namespace: DevExpress.Xpf.Core.FilteringUI

Assembly: DevExpress.Xpf.Grid.v20.2.dll

NuGet Packages: DevExpress.WindowsDesktop.Wpf.Grid.Core, DevExpress.Wpf.Grid.Core

Declaration

C#

public event EventHandler<ExcelStyleFilterElementQueryOperatorsEventArgs> QueryOperators

VB.NET

Public Event QueryOperators As EventHandler(Of ExcelStyleFilterElementQueryOperatorsEventArgs)

Event Data

The QueryOperators event's data class is ExcelStyleFilterElementQueryOperatorsEventArgs. The following 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. Inherited from QueryOperatorsEventArgsBase<T>.
FieldName	Gets a name of the field for which operators are queried. Inherited from QueryOperatorsEventArgsBase<T>.
Operators	Gets or sets operators displayed in the operator list.

Remarks

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

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:

Xaml

<dxg:GridColumn FieldName="OrderDate">
    <dxg:GridColumn.CustomColumnFilterPopupTemplate>
        <DataTemplate>
            <dxfui:ExcelStyleFilterElement x:Name="PART_FilterElement" QueryOperators="OnExcelStyleFilterQueryOperators"/>
        </DataTemplate>
    </dxg:GridColumn.CustomColumnFilterPopupTemplate>
</dxg:GridColumn>

C#

void OnExcelStyleFilterQueryOperators(object sender, ExcelStyleFilterElementQueryOperatorsEventArgs e) {
    if(e.FieldName == "OrderDate") {
        e.Operators.Clear();
        e.Operators.Add(new ExcelStyleFilterElementOperatorItem(ExcelStyleFilterElementOperatorType.Equal) { Caption = "Equal" });
        e.Operators.Add(new ExcelStyleFilterElementOperatorItem(ExcelStyleFilterElementOperatorType.NotEqual) { Caption = "Not Equal" });
    }
} 

VB.NET

Private Sub OnExcelStyleFilterQueryOperators(ByVal sender As Object, ByVal e As ExcelStyleFilterElementQueryOperatorsEventArgs)
    If e.FieldName = "OrderDate" Then
        e.Operators.Clear()
        e.Operators.Add(New ExcelStyleFilterElementOperatorItem(ExcelStyleFilterElementOperatorType.Equal) With {
            .Caption = "Equal"
        })
        e.Operators.Add(New ExcelStyleFilterElementOperatorItem(ExcelStyleFilterElementOperatorType.NotEqual) With {
            .Caption = "Not Equal"
        })
    End If
End Sub 

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.v20.2.Extensions.dll library. Refer to c:\Program Files (x86)\DevExpress 20.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 ICustomFunctionOperator interface. Refer to the Implementing Custom Functions topic for more information.

   C#

   const string CustomFunctionName = "LastYears";
   var currentYear = DateTime.Now.Year;
   
   ICustomFunctionOperatorBrowsable customFunction = CustomFunctionFactory.Create(CustomFunctionName, 
       (DateTime date, int threshold) => {
           return currentYear >= date.Year && currentYear - date.Year <= threshold;
       }
   );
   

   VB.NET

   Const CustomFunctionName As String = "LastYears"
   Private currentYear = DateTime.Now.Year
   
   Private customFunction As ICustomFunctionOperatorBrowsable = CustomFunctionFactory.Create(CustomFunctionName, 
       Function(ByVal date As DateTime, ByVal threshold As Integer) currentYear >= date.Year AndAlso currentYear - date.Year <= threshold)
   

2. Call the CriteriaOperator.RegisterCustomFunction method to register the custom function.

   C#

   CriteriaOperator.RegisterCustomFunction(customFunction);
   

   VB.NET

   CriteriaOperator.RegisterCustomFunction(customFunction)
   

3. Create the ExcelStyleFilterElementOperatorItem and add it to the ExcelStyleFilterElementQueryOperatorsEventArgs.Operators collection. Specify the operator item’s edit settings to define its operands:

   C#

   void OnExcelStyleFilterQueryOperators(object sender, ExcelStyleFilterElementQueryOperatorsEventArgs e) {
       if(e.FieldName == "OrderDate") {
           // ...
   
           var customFunctionEditSettings = new BaseEditSettings[] { 
               new TextEditSettings { MaskType = MaskType.Numeric, Mask = "D", MaskUseAsDisplayFormat = true } 
           };
           e.Operators.Add(new ExcelStyleFilterElementOperatorItem(CustomFunctionName, customFunctionEditSettings) { Caption = "Last Years" });
       }
   } 
   

   VB.NET

   Private Sub OnExcelStyleFilterQueryOperators(ByVal sender As Object, ByVal e As ExcelStyleFilterElementQueryOperatorsEventArgs)
       If e.FieldName = "OrderDate" Then
           ' ...
   
           Dim customFunctionEditSettings = New BaseEditSettings() {New TextEditSettings With {
               .MaskType = MaskType.Numeric,
               .Mask = "D",
               .MaskUseAsDisplayFormat = True
           }}
           e.Operators.Add(New ExcelStyleFilterElementOperatorItem(CustomFunctionName, customFunctionEditSettings) With {
               .Caption = "Last Years"
           })
       End If
   End Sub
   

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the QueryOperators event.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

XAML

wpf-pivotgrid-customize-filter-drop-down/CS/WpfPivotCustomFilterDropDownExample/MainWindow.xaml#L61

<DataTemplate>
    <dxfui:ExcelStyleFilterElement Name="PART_FilterElement" QueryOperators="OnExcelStyleFilterQueryOperators"/>
</DataTemplate>