Which option is used to add conditions to filter output records in an aggregate?

The use of an Aggregate Filter is essential for applying specific conditions that determine which records are returned in an aggregate. When working with aggregates in OutSystems, you often need to narrow down the data set based on particular criteria. This is accomplished by specifying filter conditions that evaluate to true or false against the records in the source data.

For example, if you have an aggregate pulling data from a database table, you can use the Aggregate Filter to specify conditions such as "status equals 'active'" or "date is greater than '2023-01-01'". Only those records that meet the specified filter criteria will be included in the output of the aggregate.

This functionality is crucial for ensuring that the data presented in your application is relevant to the user's requirements, improving both performance and user experience. The right application of filters not only helps in fetching the desired records but also contributes to a more efficient query process, as it limits the amount of data processed and returned.

In contrast, Aggregate Source refers to the underlying data set from which records are drawn but does not handle filtering. Aggregate Sorting is focused solely on ordering the records returned by the aggregate rather than filtering them. Aggregate Test Values are used for testing the behavior of inputs within aggregates but do not influence which