Prompt User to enter a value of their choice, or select LOV

A rather basic questions.

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)


mdbdome (BOB member since 2004-07-28)

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.

Does that help?


Justin Grimme :us: (BOB member since 2004-03-03)

The LOV Properties are Export with Universe.


mdbdome (BOB member since 2004-07-28)

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.


Steve Krandel :us: (BOB member since 2002-06-25)