[ROOT] / doc / toc / ARCQuery / Class / QueryExpressionAggregate

AggregationKey , AggregationType , Execute , IsSuitableAggregator , SyntaxHelp , TryCheckForExistenceOfKey


Aggregates over the given key.

Examples:
'AGGREGATE Product'.
or
'AGGREGATE Product BY Year SUM Amount'.

See SyntaxHelp.

See also:
QueryExpressionPivot which aggregates over two keys (row key and column key).
and
FunctionKeyAggregate which operates over a collection of properties.

TODO: As of Nov 2020 there is lot of similar code in QueryExpressionPivot and -QueryExpressionAggregate.


AggregationKeyThis is often null (with AggregationType correspondingly set to Count-).
AggregationTypeMost common value is Count, in which case AggregationKey may be correspondingly set to null.
ExecuteTransforms the given input collection into a resulting collection.
IsSuitableAggregatorReturns true if
SyntaxHelp1) 'AGGREGATE {rowKey}' like "AGGREGATE Product"
TryCheckForExistenceOfKeyUsed by query expressions in order to catch wrong field names used or misspelling of field names.

Details

Generated 2024-03-29 01:22:32.121 UTC