BusinessObjects Board

* in lov

building semantic layer
#1

Hi,

I am trying to create prompts for accepting ‘*’ for all values of lov using the below syntax, but couldn’t get it right somehow.

@Select(class\object) IN @Prompt(‘Select blah’,‘A’,class\object’,multi,free) or (’*’ IN @Prompt(‘Select blah’,‘A’,‘class\object’,multi,free))

Can anyone please elaborate on this.

Thanks

bodummy (BOB member since 2005-01-12)

#2

Didn’t the FAQ (https://bobj-board.org/t/15227/9) help you out?

jobjoris :netherlands: (BOB member since 2004-06-30)

#3

Thanks Jobjoris,

My problem is… i am unable to implement the ALL option at report level. i could override SQL of lov and get ALL option listed in the lov but when i select ALL option always getting “no data to fetch”

I think ALL is being taken as a literal and not as a substitute for all values of lov. how do we tell BO that when ALL is selected in prompt, the query should include all the values in lov file

bodummy (BOB member since 2005-01-12)

#4

We tell BO to just fetch all records/values by saying “all” equals “all”. So if it doesn’t work, you just haven’t done all the steps mentioned in the FAQ correctly. Did you change the ‘*’ from your initial post to “All”?

jobjoris :netherlands: (BOB member since 2004-06-30)

#5

this is mentioned in the FAQ’s but yet again
at the universe level you might want to add
union all
select ‘*ALL’ from Dual

chander165 :us: (BOB member since 2005-12-20)