Prompt - Add ALL in the List of values

[system]

Hi all,

I am currently using BO 6.5.x and I need to a prompt where the user can select values from list of values. The user can also select ‘ALL’ from list of values.

The database table do not have ‘ALL’ as record, so I need to manipulate such that user can see ‘ALL’ in the list of values.

I was trying the following code as per the BO documentation but its not working.

@Select(Trader\Company Name) IN @Prompt(‘Select one/more/ALL Traders from list’,‘A’,{‘ALL’},‘Trader\Company Name’,multi,free)

When I add {‘ALL’} in the prompt, it is failing.

Any help/suggestion in this regard would be highly appreciated.

Thanks,
Satya

---

bsatyaprasad (BOB member since 2007-05-08)

[system]

There are a couple of entries in the Designer FAQ that detail the steps you need to take. The work to add ALL to the LOV has to be done in the Universe Designer, thus the FAQ entries are in the same forum.

---

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

[system]

Thanks a lot.

I found the details as mentioned above.

For details,

FAQ: Designer

[b:1d54a67631]Designer FAQ[/b:1d54a67631] [url=http://www.forumtopics.com/busobj/viewtopic.php?p=495481#495481]How should I impose a WHERE clause in my object(s) in the universe?[/url] [url=http://www.forumtopics.com/busobj/viewtopic.php?p=43275#43275]Is there any way to set up a prompt that will allow a user to select one value, many values, or type 'ALL' for all values in a list? [/url] [url=http://www.forumtopics.com/busobj/viewtopic.php?p=99071#99071]Now that my LOV lets me use ALL for al…

---

bsatyaprasad (BOB member since 2007-05-08)

[system]

Hi.

Try this:

1. In designer select the object in question and double click to open the properties
2. In Properties dialog select the Properties tab
3. Under list of values click edit
4. In the Query Panel click View SQL
5. Update the SQL as outlined below

SQL Before Update:

SELECT    DISTINCT
  TABLE_NAME.COL_NAME
FROM
  TABLE_NAME

Edit this to :

SELECT '*ALL*' FROM DUAL
UNION
SELECT    DISTINCT
  TABLE_NAME.COL_NAME
FROM
  TABLE_NAME

Note that I use ‘ALL’ to ensure that the ALL appears at the top of the list.

6. Important : Tick “Do not generate SQL before running”
7. Click OK, OK, OK.
8. Change definition of your Filter Object as outlined below.

@Select(Trader\Company Name) IN @Prompt('Select one/more/ALL Traders from list','A','Trader\Company Name',multi,free)
OR '*ALL*' IN @Prompt('Select one/more/ALL Traders from list','A','Trader\Company Name',multi,free)

Hope this helps.

---

stephenEclectic (BOB member since 2004-12-07)