What feature in aggregates is equivalent to SQL ORDER BY?

The feature in aggregates that serves the same purpose as SQL's ORDER BY clause is Aggregate Sorting. This function allows developers to specify the order in which results will be returned from the aggregate, based on one or more attributes. By using Aggregate Sorting, you can arrange records in ascending or descending order, similar to how you would format your SQL queries.

In the context of OutSystems, using this sorting functionality helps to present data in a meaningful way, making it easier for users to understand and interact with the information displayed on screens. This functionality is fundamental in ensuring that data presentation aligns with user expectations, enhancing the user experience.

Other options do not apply here: an Aggregate Filter is used to limit the data returned based on certain criteria, while an Aggregate Source refers to the underlying data being pulled into the aggregate. Aggregate Test Values relates to testing functionality within the development environment but is not associated with result ordering.