Specifies whether aggregation operations such as SUM, COUNT, and GROUP BY should be performed on the Certinia server or handled by the client.

Data Type

bool

Default Value

true

Remarks

When ServerSideAggregation is set to true, the component pushes aggregation logic to the Certinia API, reducing client-side processing and improving efficiency for smaller or well-structured queries. However, there are limitations with server-side aggregation. For example, if you run an aggregation query on a non-primary key field that returns more than 2,000 records, Certinia may return an EXCEEDED_ID_LIMIT error. In these cases, setting ServerSideAggregation to false forces the component to perform the aggregation on the client side, allowing the query to complete without hitting this limitation.

Enabling server-side aggregation offloads processing to Certinia and can significantly improve query speed for supported operations and smaller result sets. However, large aggregations on non-primary key fields may fail due to API limits. Disabling this property shifts aggregation processing to the client, which can avoid API errors but may increase local resource usage and processing time.

This property is useful when working with large datasets or queries that aggregate on non-primary key fields, allowing flexibility to handle limitations in Salesforce’s aggregation capabilities.