Show list of values missing

building semantic layer
1

Using the Query Panel in Designer, how do you limit which fields from an LOV are displayed? When trying to edit an LOV and I choose the object to place conditions, the “show list of values” option is not available to me.

In designer when I double click the object and go to the properties section and click on edit to go to the query panel there I find the selected object in the Results object. When I drag the same object to the codition panel and select inlist and there I am unable to find the operand show list of values for that particular object that is being selected. I want to apply a filter on list of values of the selected object.

Please advise.

bobjkb :india: (BOB member since 2004-03-19)

2

What you probably want to do is display your entire LOV and then when the values window is up you need to select (filter) the values you want to display/associate to this LOV and then check “Show selected only”.

jswoboda :us: (BOB member since 2002-06-20)

3

thanks for your promt reply jeffrey …
but please advice me why is this happening(i.e 2nd para)
Thanks and regards

bobjkb :india: (BOB member since 2004-03-19)

4

You are trying to display an LOV for the same object in which you are creating the LOV. “Show list of values” is not an option within the Edit LOV panel. You can type in values but if you want to actually select or filter on the values you will need to used the method I described. - thx

jswoboda :us: (BOB member since 2002-06-20)

5

Hello,

This is my first time here. I have the same problem. I am not able too see the List Of Value Option too. I followed the same procedure as below.

In designer when I double click the object and go to the properties section and click on edit to go to the query panel there I find the selected object in the Results object. When I drag the same object to the codition panel and select inlist and there I am unable to find the operand show list of values for that particular object that is being selected. I want to apply a filter on list of values of the selected object.
I tried to do what you have mentioned to but still i dont get the option of LOV.
I am working on BO 6.5.1, Oracle 9.2.

Thanks

vanquisher (BOB member since 2007-06-05)

6

You can’t use the LOV query while you are editing it. :slight_smile:

What you described is: you have opened the LOV query. From there you want to apply a condition. While you have the LOV query open in the editor, you cannot “show list of values” for that object, because the query definition is not complete. You have to use an alternate object for your condition, or make the selection manually.

Dave Rathbun :us: (BOB member since 2002-06-06)

7

Hi Dave,

Thanks for the quick reply. Well i said i am not getting the List of values option when i click the Inlist. I am doing this at the Universe Level.

Can you please help me.

Thanks in advance

vanquisher (BOB member since 2007-06-05)

8

What you said was:

What I said was:

Dave Rathbun :us: (BOB member since 2002-06-06)

9

Thank You, Got it

vanquisher (BOB member since 2007-06-05)