Skip to main content

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.

Hi ​@clerm ,

The 'distinct' keyword is not supported for IFS applications. The 24R1 version introduced enhanced mechanisms for validating data source configurations, which is why the error message indicates incorrect configuration. It seems that you have found a workaround to use the 'distinct' keyword in previous versions. However, it is not officially supported.

​@clerm it’s strange. I’m also on 24R1 and I can use DISTINCT in the datasource definition.

Above I just quickly edited a COUNT(invoice_id) into DISTINCT invoice_id and it returns results. Maybe the validation that ​@Viranga Ruwanpathirana mentions was intoduced in 24.1.1 or maybe 24.1.2?

Can you open the debugger and have a look at the response you get from the server in the Network or IFS Cloud tab of the debugger? The toast message doesn’t reveal the actual error message.

Reply


Terms & ConditionsCookie settings