Retreive Distinct rows

1
Hello, How to get distinct rows from a table in mendix, Please help me with this. Thank you.
asked
1 answers
3

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

answered