When using aggregation functions, will the output of the Aggregate include the columns at grey?

The output of the Aggregate in OutSystems will include the columns that are marked as grey because these represent the attributes that are being used in the aggregation and are part of the final output. In OutSystems, when you define an Aggregate, you specify which data you want to retrieve and which functions you want to apply, such as SUM, AVG, or COUNT.

When attributes are shown in grey within the Aggregate, it indicates that they will be included in the results as part of the selection criteria and will also be part of the output data structure. This helps to clarify the data being processed and enables the developer to better understand what information will be available after the Aggregate execution.

In contrast, if the attributes were not included, they would not show in the output, and understanding the result set would be compromised. This behavior allows for a straightforward approach in defining data retrieval strategies while leveraging OutSystems’ built-in capabilities for data manipulation and retrieval.