Creates an AggregationColumn
object for use inside an Aggregation
object.
a!queryAggregationColumn( field, alias, visible, isGrouping, aggregationFunction )
false
, the data for the column will not be retrieved, but it can be used for sorting. Default value is true
.false
.COUNT
, SUM
, AVG
, MIN
, and MAX
. Requires isGrouping to be false
.YEAR
and MONTH
. This parameter can only be used with Date
and Date and Time
data types. Requires isGrouping to be true
.AggregationColumn
Aggregation: The Aggregation data type defines the grouping and aggregation configuration to be applied when querying data.
AggregationColumn: The AggregationColumn data type defines an individual configuration of grouping and aggregation to be applied when querying data.
Query: The Query data type defines the grouping, aggregation, filtering, paging, and sorting configuration to be applied when querying data.
Aggregate Data on a Date Field Recipe: This query recipe demonstrates how to aggregate data from a data store entity on a date or date and time field.