When designing queries, it's common to add conditions to filter results and get exactly what you want from the database. You can do this in OutSystems 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.