Skip to main content
All docs
V24.1

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.v24.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