Select distinct

1
Hi Experts,   Is there a possibility in Mendix to get a list, but without double records ?  Like you would do with a simple SELECT DISTINCT statement.   Regards
asked
2 answers
8

Hi,

You can try OQL queries in mendix to do the same. Please find the below reference,

https://docs.mendix.com/refguide/oql

https://mydemoversion8-sandbox.mxapps.io/p/OQL

Thanks!

 

answered
0

Hi Dzhengis,

 

When you start using OQL, be aware that the maintainability of your project will decrease.

Mendix offers a range of operations you can perform on a list, that will suite your case too.

Have a look at this documentation page, and specifically the UNION operation. When you perform the UNION on the same list, it will return a list of the chosen object type, avoiding duplicates.

I think this fits your use case perfectly.

 

Good luck!

answered