Aggregate Enum
Enumerates aggregate functions.
Namespace: DevExpress.Data.Filtering
Assembly: DevExpress.Data.v24.2.dll
Declaration
Members
| Name | Description |
|---|---|
Exists
|
Determines whether the object exists in the collection. |
Count
|
Returns the number of objects in the collection. |
Max
|
Returns the maximum expression value in the collection. |
Min
|
Returns the minimum expression value in the collection. |
Avg
|
Evaluates the average of the values in the collection. |
Sum
|
Returns the sum of all the expression values in the collection. |
Single
|
Returns a single object from the collection. The collection must contain no more than one object. |
Custom
|
Returns a custom aggregate function‘s result. |
Remarks
The values listed in this enumeration are used to set the AggregateOperand.AggregateType property.
AggregateOperand does not support nested expressions and complex property paths like Max(Document.<PersonID>LastName). Only names of owned properties are supported: Max(Document).
AggregateOperand may produce null instead of zero for an empty collection on a server side.
The Single function requires that the collection contain no more than one object. If the collection contains more objects, use the Condition property to specify a condition. The collection must contain only one object that satisfies the condition; otherwise, the function’s behavior is undefined (the function may return an unexpected value or throw an exception).