I have a prompt which allows the Users to select many values from the LOV or add their own. Unfortunately, I cannot see the list of values when the LOV is edited. The Oracle database at the backend shows the LOVs
TIA
Definition of LOV
Table1.Col1
Where
Table1.Col1 in @Prompt(‘Enter or select the values to be viewed’,‘A’,ltrim’Table1\Col1’,multi, free)
Is the LOV you are talking about set to export with the universe? You can make this change in designer by opening the universe, select the object you have a LOV for and select object properties. Then select the properties tab, and make sure that the “export with universe” is selected under the List of Values options at the bottom.
The problem is that you don’t have proper syntax. You can’t apply ANY functions to your LOV in the @prompt statement.
What are you really trying to do? I’ve never seen anyone put an @prompt for a LOV where it refers to the exact same column. What concerns me is that you’ve created a very circular reference.