Retrieve a distinct list

Question

Retrieve a distinct list

12

It will be fantastic, for performance purposes to add a way to retrieve distinct data with a retrieve action.

asked 2016-11-14

Masterman Barimah Aboagye

2 answers

Masterman Barimah Aboagye · Answer 1 · 2016-11-14

for example, If I retrieve a list of actions, as shown bellow

modelshare example

I will get a single list of actions that is an or between Action objects of _Type add and edit , sorted by created date , desc.

I would like to be able to specify a distinct column attribute,in the retrieve (for example Action._Type) so that this retrieve, will perform a distinct operation on the two subset based on Action._Type (add and edit) and the sorting,and then perform the or operation, which will return a distinct list of object based on chosen column.

Jasper van der Hoek · Answer 2 · 2016-11-14

Can you clarify what you mean with a distinct list? If you do a retrieve the platform already only retrieves unique Mendix objects? A db or association retrieve won't give you the same object twice.