When designing queries, it is common to add conditions to filter results and get exactly what you want from the database. In OutSystems, this is done by adding Filters to Aggregates, as follows:
- Double-click to open the Aggregate.
- Open the drop-down menu of an attribute and select Filter....
- Enter the condition.
To edit the conditions, go to the Filters option and change the ones you want to alter.