Skip to main content

 

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

Get Distinct Values from the Database

Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub
  • 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