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