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 toAggregate
, the Filter Editor creates a single aggregate condition:If you set the
AllowFilterEditorAggregateOperands
property toAggregateWithCondition
, the Filter Editor creates two conditions:- An aggregate condition for the collection.
- 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.