Retreive Distinct rows
Hello, How to get distinct rows from a table in mendix, Please help me with this. Thank you.
In a microflow, you can do the following:
- Retrieve the rows from the entity (lets call the resulting list $Rows)
- Perform a list operation of type Union
- Select $Rows as both arguments for the list operation
- Specify the name of the output, lets say $DistinctRows
$DistinctRows will now contain a list of the unique objects in list $Rows