How to display unique values (no duplicates) from SQL DB in a dropdown?

0
Hi everyone, I'm building an app in Mendix and I have a question about how to display data from an external SQL database. I’m retrieving data from a SQL DB, and one of the columns is called customer.This column contains multiple records with the same customer value. I want to show a dropdown on the page that displays only the unique customer values (no duplicates). What would be the best approach to achieve this in Mendix?Any recommendations or best practices would be greatly appreciated! Thanks in advance for your help.
asked
1 answers
1

If you're using the database connector, you can use a sql query that only retrieves unique values, e.g, by using distinct or group by.

answered