Skip to main content
All docs
V25.1
  • DevExpress v25.1 Update — Your Feedback Matters

    Our What's New in v25.1 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

    DataViewBase.AllowFilterEditorAggregateOperands Property

    Gets or sets whether users can create aggregate filters in the Filter Editor. This is a dependency property.

    Namespace: DevExpress.Xpf.Grid

    Assembly: DevExpress.Xpf.Grid.v25.1.Core.dll

    NuGet Package: DevExpress.Wpf.Grid.Core

    #Declaration

    public AllowFilterEditorAggregateOperands AllowFilterEditorAggregateOperands { get; set; }

    #Property Value

    Type Description
    AllowFilterEditorAggregateOperands

    Specifies whether users can create aggregate filters in the Filter Editor.

    Available values:

    Name Description
    No

    Users cannot create aggregate filters.

    Aggregate

    Users can create aggregate filters against collection properties.

    AggregateWithCondition

    Users can create aggregate filters against collection properties and collection items.

    #Remarks

    You can use the Filter Editor to filter data by items in bound collection properties. The AllowFilterEditorAggregateOperands property specifies how users can create aggregate filters:

    • If you set the AllowFilterEditorAggregateOperands property to Aggregate, the Filter Editor creates a single aggregate condition:

      WPF Filter Editor - Simple Aggregate Filters

    • If you set the AllowFilterEditorAggregateOperands property to AggregateWithCondition, the Filter Editor creates two conditions:

      WPF Filter Editor - Sample Aggregate Filter

      1. An aggregate condition for the collection.
      2. An additional condition that allows you to pre-filter collection items.

      Only items that pass the additional condition participate in aggregate calculation.

      Conditions above filter data by the Genres column. This column is bound to a collection property. Collections contain items with Name and Value properties. The filter displays rows that contain items with the maximum Value greater that 5 among items with the ‘1’ character in their Name.

    The Filter Editor displays all aggregate operators when you set the AllowFilterEditorAggregateOperands property to Aggregate or AggregateWithCondition. Use the ColumnBase.AllowedAggregateFilters property to customize the operator list for the column.

    Note

    We recommend that you create aggregate filters only against columns of types that implement the IList<T> or IList interface.

    Refer to the following help topic for more information: Aggregate Filters.

    See Also