BusinessObjects Board

All in LOV

Hi,

I want to display ‘ALL’ in my list of values so that instead of selecting all values user can directly click on ‘ALL’ and it selects all values in list.

Also,I want to know how does it work,in some posts I read that by typing * or by typing ALL it selects all values.I wanted to know the logic behind this as how it interprets this * or ‘ALL’.

Regards,

Arun


binnu23 :india: (BOB member since 2010-05-21)

Take a look at this :

https://bobj-board.org/t/15227/9


Raghvendra Deshpande :india: (BOB member since 2008-05-26)

Thanks Raghvendra.

I got the first part of that i.e. overriding the LOV Sql but didn’t get the second part of universe object.


binnu23 :india: (BOB member since 2010-05-21)

Arun, follow this steps-

  1. Create a variable and write - ’ All’.
  2. Associate it with any table or sysdual as suggested
  3. Go to Properties of object and Edit Query.
  4. Add combined query in that with the object in which you would wish to see All option.
  5. Save and Run
  6. Check if now All option is visible in LOV.

aniketp :uk: (BOB member since 2007-10-05)

All will based on a simple SQL logic

i.e where
Table.Column=@Prompt()
or ‘All’ =@Prompt()

In the above logic if you select any column value the first condition will execute and returns the data based on the selected value. If you select all from the lov’s the second condition will be true and you will get the complete data.

I hope this helps …


sams_d7 :india: (BOB member since 2007-07-24)

Please note that adding “ALL” to the list of values doesn’t mean that this will work in a report-level prompt or filter.

It will only work with a universe-level condition that specifically looks for the “ALL” value.


Tom Thompson :us: (BOB member since 2003-06-04)