Retrieve a unique list

0
I try to retrieve a unique list based on an association. Now I have try to do this in the retrieve but can’t find how to do this, I know it is possible in SQL with select distinct. Now I have solved this in a microflow by walking through the list and filter the unique objects. But this is not particularly fast. IS there I way I can do this faster?  
asked
3 answers
1

Check out the list actions https://docs.mendix.com/refguide/list-operation

Union is the one you're looking for I think, just pass the retrieved list in the list operation UNION and you get an unique list.

answered
1

Do you mean unique objects? How do you retrieve duplicate objects by association? 

answered
0

There should never be duplicated in a list that has been retrieved by association.

Unless of course you meant that there is some attribute eg. ‘Name’ in your retrieved entity which might be the same for multiple objects?

answered