a!queryAggregationColumn( field, alias, visible, isGrouping, aggregationFunction, groupingFunction )
Creates an AggregationColumn
object for use inside an Aggregation
object.
See also: Aggregation, AggregationColumn, Query
Keyword | Type | Description |
---|---|---|
|
Text |
The dot-notation to the field of the data, such as a record type, you want to group together and/or aggregate. The fields cannot be complex or multiple values. |
|
Text |
The short name by which the result of the AggregationColumn value can be referenced in other places of the Query value. Values are case-sensitive. |
|
Boolean |
Determines whether the grouping or aggregation column should be visible to end users. If false, the data for the column will not be retrieved, but it can be used for sorting. Default value is |
|
Boolean |
Determines whether the field should be grouped. Default value is |
|
Text |
The function to use when aggregating the field. Valid values include |
|
Text |
A function that can be applied on the selected field. Valid values are |
AggregationColumn
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!queryAggregationColumn() Function