BusinessObjects Board

To retrieve all values when selected ALL

building semantic layer
#1

Hi I have added All in countries object but how to tell BO when a user selects ALL from LOV it should select all the values in that object.
can any one help regarding this?

phaada :india: (BOB member since 2007-10-12)

#2

Hi,

Below prompt code will help you.


@Select(classname\object name)
IN @Prompt('1. Select xxx or ALL','A', 'class name\object name' ,multi,free) OR 'ALL' 
IN @Prompt('1. Select xxx or ALL','A', 'class name\object name' ,multi,free)

Arun.kumar :us: (BOB member since 2007-10-25)

#3

Already covered in the FAQ, as well as a gazillion other posts, thanks. :wink:

Related Designer FAQ post

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

#4

Hi,
An alternative way to select all values without using ‘OR’ operator to optimize the query performance could be like this…

(case when 'ALL' IN @Prompt('Select xxx or ALL','A',''class name\object name',Multi,Constrained,,,) then 'ALL' else @Select('class name\object name') end) IN @Prompt('Select xxx or ALL'','A','class name\object name'',Multi,Constrained,,,)

Works fine with ORACLE… yet to confirm with other DB.

Thanks,
Sbhusan

sbhusan :canada: (BOB member since 2006-06-26)