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
Retrieve the List.
Sort the List by Name ascendingly.
Create a New List.
Create a variable Name.
Loop the Sorted List.
Decision IteratorSortedList != Name.
6a.1. (IF TRUE) Add the Sorted List to New List.
6a.2. Set IteratorSortedList/Name to variable Name.