Skip to Content
0
Sep 13, 2016 at 02:11 PM

Prompt with List Of Values

37 Views

Hi all,

do you know if there is a limitation concerning the usage of prompts with a LOV coming from a .unx universe?

We migrated a .unv universe to .unx and found out that the LOV won't work when using Lumira.

Also applying corrections to the SQL-statement won't fix the issue.

It is a complex statement and we always get the error message:

[Vertica][VJDBC](3436) ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in the SELECT clause

But we have all these expressions in the SQL statement.

We are currently using Lumira 1.31.

Thanks and BR

Agnetha