Description

Standard aggregations calculate results based on several input rows into single values.

Which rows are aggregated into a single value is defined by the grouper columns. Every column within one query which is not an aggregation is implicitly a grouper. If no grouper is defined, all values are aggregated into one group.

The implicit grouping is the main difference to SQL. PQL has no 'GROUP BY' clause. Besides that the aggregation sticks close to SQL.

Aggregations take filters and selections into account. Values which are filtered out are not part of the result. Therefore if a filter or a selection is changed every aggregation is recalculated.