Hello all,

We recently upgraded from 22.2.14 to 24.1.2.

Our lobby datasources no longer work with a ‘DISTINCT’ in the column definition. They worked fine in 22R2. I tried adding a DISTINCT to a simple standard IFS datasource and it also did not work. All of the Queries seem to work fine in SQLDevelopper.

Is DISTINCT no longer supported in datasource column definitions, or does it have to be implemented in a certain way? If so, what is the good implimentation method?

Error message: Could not preview element. Make sure datasource is configured correctly and view is existing.

Sample attached, but it could be any datasource.