Unique values in report drop-down list

Hi, What OQL do I have to use to only show distinct values in my drop-down list? I have 4 countries: England, Wales, Scotland, Northern Ireland. I only want these to appear once in the drop-down but my drop-down shows the country for every record, so am I missing a DISTINCT clause somewhere? I have exhausted my OQL/SQL skills! Any help will be much appreciated, David
1 answers

Why not create a Country entity in your domain model and have one record for each country? Then you can create an association between your entity and the Country they are located in. The drop-down based on the association will then only show your distinct country records.

Edit: The first thing you need to do is a Retrieve action from the Database and get the First record only where the Country name = your value, like:


Then use the record retrived in a Change ation to set the value of the association, like:

Set association

Here is the image for the latest comments: new country