The ability to filter out distinct records directly from the database. - Mendix Forum

The ability to filter out distinct records directly from the database.

0

It would be highly beneficial to have an option for retrieving distinct records directly from the database, rather than processing all the records and manually filtering out duplicates. This approach would significantly reduce execution time, especially when dealing with large datasets, as it would eliminate the need to traverse thousands of records just to identify unique entries.

asked
1 answers

Hi Krunal,

Are you aware that you can use OQL to get distinct values? See https://community.mendix.com/link/space/databases/questions/124508 for example.

Kind regards,

Michiel

Created