a!queryAggregation() Function

Function

a!queryAggregation( aggregationColumns )

Creates an Aggregation object for use inside a Query object.

See also: Aggregation, AggregationColumn, Query

Keyword	Type	Description
`aggregationColumns`	List of AggregationColumn	A list of AggregationColumns that indicate which fields to group or aggregate, created with a!queryAggregationColumn.

Aggregation

The aggregationColumns parameter is required.

The table below lists this function's compatibility with various features in Appian.

Feature	Compatibility	Note
Portals	Partially compatible	Can be used with Appian Portals if it is connected using an integration and web API.
Offline Mobile	Partially compatible	Can be used with offline mobile if it is loaded at the top of the form.
Sync-Time Custom Record Fields	Incompatible
Real-Time Custom Record Fields	Incompatible	Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.
Process Reports	Incompatible	Cannot be used to configure a process report.
Process Events	Incompatible	Cannot be used to configure a process event node, such as a start event or timer event.

a!queryAggregation() Function