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.2.Core.dll
NuGet Package: DevExpress.Wpf.Grid.Core
#Declaration
public AllowFilterEditorAggregateOperands AllowFilterEditorAggregateOperands { get; set; }
#Property Value
Type | Description |
---|---|
Allow |
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. |
Aggregate |
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
Refer to the following help topic for more information: Aggregate Filters.