ColumnView.FilterPopupExcelQueryFilterCriteria Event

Allows you to modify criteria expressions built when users filter Data Grid data in Excel-style filtering menus.

Namespace: DevExpress.XtraGrid.Views.Base

Assembly: DevExpress.XtraGrid.v18.2.dll

Declaration

C#

[DXCategory("Behavior")]
public event FilterPopupExcelQueryFilterCriteriaEventHandler FilterPopupExcelQueryFilterCriteria

VB.NET

<DXCategory("Behavior")>
Public Event FilterPopupExcelQueryFilterCriteria As FilterPopupExcelQueryFilterCriteriaEventHandler

Event Data

The FilterPopupExcelQueryFilterCriteria event's data class is DevExpress.XtraGrid.Views.Grid.FilterPopupExcelQueryFilterCriteriaEventArgs.

Remarks

In the example below, a sample application displays video data. The “Tag” field stores video tags separated by commas as a single string. The ColumnView.FilterPopupExcelData event splits these strings into individual tags available for end-users from the “Values” tab of Excel-styled filters. The FilterPopupExcelQueryFilterCriteria event is handled to replace the default “Equals” condition with “Contains”.

C#

using DevExpress.Data.Filtering;
using DevExpress.Utils.Filtering.Internal;

//create items that represent individual tags
private void GridView1_FilterPopupExcelData(object sender, DevExpress.XtraGrid.Views.Grid.FilterPopupExcelDataEventArgs e) {
    if (e.Column.FieldName == "Tag") {
        var tags = e.DataItems.SelectMany(x => x.Text.Split(',', ';'))
            .OrderBy(x => x)
            .Distinct()
            .ToArray();
        e.DataItems.Clear();
        for (int i = 0; i < tags.Length; i++)
            e.AddData(tags[i], tags[i]);
    }
}

//modify filter criteria expressions
private void GridView1_FilterPopupExcelQueryFilterCriteria(object sender, DevExpress.XtraGrid.Views.Grid.FilterPopupExcelQueryFilterCriteriaEventArgs e) {
    if (e.Column.FieldName == "Tag") {
        var viewModel = e.Value as ICollectionValueViewModel<string>;
        OperandProperty property = new OperandProperty(e.Path);
        e.FilterCriteria = GroupOperator.Or(viewModel.Values.Select(x =>
                            new FunctionOperator(FunctionOperatorType.Contains, property, x)));
    }
}

VB.NET

Imports DevExpress.Data.Filtering
Imports DevExpress.Utils.Filtering.Internal

'create items that represent individual tags
Private Sub GridView1_FilterPopupExcelData(ByVal sender As Object, ByVal e As DevExpress.XtraGrid.Views.Grid.FilterPopupExcelDataEventArgs)
    If e.Column.FieldName = "Tag" Then
        Dim tags = e.DataItems.SelectMany(Function(x) x.Text.Split(","c, ";"c)).OrderBy(Function(x) x).Distinct().ToArray()
        e.DataItems.Clear()
        For i As Integer = 0 To tags.Length - 1
            e.AddData(tags(i), tags(i))
        Next i
    End If
End Sub

'modify filter criteria expressions
Private Sub GridView1_FilterPopupExcelQueryFilterCriteria(ByVal sender As Object, ByVal e As DevExpress.XtraGrid.Views.Grid.FilterPopupExcelQueryFilterCriteriaEventArgs)
    If e.Column.FieldName = "Tag" Then
        Dim viewModel = TryCast(e.Value, ICollectionValueViewModel(Of String))
        Dim [property] As New OperandProperty(e.Path)
        e.FilterCriteria = GroupOperator.Or(viewModel.Values.Select(Function(x) New FunctionOperator(FunctionOperatorType.Contains, [property], x)))
    End If
End Sub