Skip to main content

Developing an Application

 

OutSystems

Get Distinct Values from the Database

Database tables may have columns containing repeated values. There are situations when you only want to get the distinct values, instead of all the data including the repetitions. To obtain distinct values of entity attributes, you can use an aggregate with grouped columns.

To get distinct values of an entity attribute:

  1. In an aggregate in the action flow, add the entity.
  2. Hover on the attribute for which you want to obtain distinct values, click Aggregate Menu and choose to group by the attribute.

Get Distinct Values From the Database

The aggregate only outputs the attribute values that are grouped.

To get distinct values using multiple entity attributes, select all the required attributes and choose to Group by selected attributes.

Get Distinct Values From the Database

  • Was this article helpful?