Skip to main content

Aggregate Enum

Enumerates aggregate functions.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v24.1.dll

NuGet Package: DevExpress.Data

Declaration

public enum Aggregate

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

See Also