select top 1 record from each group in mendix

We have 2 entities. Customer and Feedback. One customer can have multiple feedback. We need to create report of All customers with latest record feedback. means how we can implement select top 1 from each group in mendix
1 answers

Hi Gopal,


  1. Retrieve the List.
  2. Sort the List by Name ascendingly.
  3. Create a New List.
  4. Create a variable Name.
  5. Loop the Sorted List.
  6. Decision IteratorSortedList != Name.

           6a.1. (IF TRUE) Add the Sorted List to New List.

           6a.2. Set IteratorSortedList/Name to variable Name.

           6b. (IF FALSE) Go to 7.

      7. Merge.