BusinessObjects Board

"All" option in prompt LIST of VAlues

Hi All,
I have created a multi select Prompt showing the list of values to the user.
and i would like to add a “ALL” option in list of values which when selected by user will retrieve all the data.

for example :

i want deptno lovs as 10,20,30,40,all

Thanks
Buggaa.


buggaa (BOB member since 2007-01-26)

Hi,

These Designer’s FAQ entries will help:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hi Create on user object at universe level and put ‘All’ in the select defination property of the object.

and then you can map tha same object with or condition with the prompt.it will allow user to chosse any thing or user can type All and get all the records.
:wink:


yadav_anil14 :india: (BOB member since 2009-06-25)

Hi,

I found this solution …


Author: Dwayne Hoffpauir

There are two approaches - overriding the LOV SQL, and creating a universe object.

Overriding the LOV SQL

  1. Press the SQL button in the query panel of the LOV
  2. Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FROM table)
  3. Click the “Do not generate SQL before running” checkbox.

Universe Object

  1. Create a universe object defined as a constant ‘ALL’
  2. Associate it with the SYS.DUAL or equivalent table so it will parse (optional)
  3. Press the combined query button in the query panel of the LOV (defaults to UNION)
  4. Include the new universe object.

it is working…

but user should type in “ALL” to get the data for all values.

i would like to get "ALL’ in the LOV’s so that user can select it instead of typing.

Thanks


buggaa (BOB member since 2007-01-26)

Hi Anil,
Is there a option to include “ALL” in the list of values instaed of user typing “ALL”

Thanks


buggaa (BOB member since 2007-01-26)

Hi,

Have you tried at least reading the links I posted? The solution is there, just read it:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hi ,
I got the solution now…

simply followed this 3steps…

Overriding the LOV SQL

  1. Press the SQL button in the query panel of the LOV
  2. Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FROM table)
  3. Click the “Do not generate SQL before running” checkbox.

Thanks


buggaa (BOB member since 2007-01-26)

We’ve have been using a method like this for a while in BO 6.5. The prompt still works in BO XI r2 Desktop Intelligence.

However, when I try and get the prompts in Infoview, it doesnt work. It just seems to hang for ever. Anyone else use this method or know an alternative?

I have created an object to return ‘All’ and UNIONED this in the LOV for our “Name” object. We are then using a predefined filer with the following:

@Select(Contact\Name(All)) in @Prompt('Please select Name or ALL',A,
'Contact\Name (All)',Multi,FREE) 
OR '*ALL*' in 
@Select(Contact\Name(All)) in @Prompt('Please select Name or ALL',A,
'Contact\Name (All)',Multi,FREE)

[Moderator Edit: Added code formatting - Andreas]


rob_bo :uk: (BOB member since 2005-08-04)

For those on version 3.x you may use optional prompts which make the ‘Adding ALL to a List of Values’ solution somewhat obsolete :smiley: :+1:


Joe Szabo :us: (BOB member since 2002-08-19)

version 3.1 is the answer to everything; seems like. hehe


ashmem (BOB member since 2008-05-21)

I heard version 3.2 is released yesterday…may be even better :slight_smile:


Diana_baker (BOB member since 2005-03-18)

hi rob,

This methods works absolutely fine in infoview…

Check for some other problem


rohit12 :india: (BOB member since 2008-11-08)

I found the problem…

My prompt had double quotes : ‘Please select Name or “ALL”’

This doesnt affect desktop intelligence but it was obviously messing up the javascript.

Thanks anyway
Rob


rob_bo :uk: (BOB member since 2005-08-04)