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
AllowFilterEditorAggregateOperandsproperty toAggregate, the Filter Editor creates a single aggregate condition:
If you set the
AllowFilterEditorAggregateOperandsproperty 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.