system
July 11, 2014, 11:08am
#1
Hi Folks,
I have a Prompt as Region, Where values are APAC, EMEA,LATAM & NORAM (Coming from database table).
Now want to add one more Value as “ALL” (Store all the 4 Regions), i.e if any user use Region prompt as “ALL”. and result should return data for all the regions.
Please suggest how could i achieve this.
Thanks,
Saurabh
Saurabh Upadhyay (BOB member since 2012-09-25)
system
July 11, 2014, 11:39am
#2
Hi,
This Designer’s FAQ will help:
Now that my LOV lets me use ALL for all values, how do I get the ALL in the list?
Author: Dwayne Hoffpauir
There are two approaches - overriding the LOV SQL, and creating a universe object.
Overriding the LOV SQL
Press the SQL button in the query panel of the LOV
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 FRO…
Marek Chladny (BOB member since 2003-11-27)
system
July 11, 2014, 12:54pm
#3
Can you simply make the prompt optional? That would be the preferred choice since you’re working in Webi…
Dave Rathbun (BOB member since 2002-06-06)
system
July 15, 2014, 11:15am
#4
Hi Marek,
Thanks for the link.
However, getting error in “@Prompt (‘Select Region or enter * for all Regions’,‘a’,‘Branchcode Hierarchy\Region’,multi,free)”
Parsing Failed.
Can you please suggest,What is the error in this ?
Thanks.
Saurabh Upadhyay (BOB member since 2012-09-25)
system
July 15, 2014, 11:17am
#5
Hi Dave,
Yeah i have already tried this , it is working.
But i want to show a prompt value as ALL to the end users.
Regards
Saurabh Upadhyay (BOB member since 2012-09-25)
system
July 15, 2014, 12:44pm
#6
However, getting error in “@Prompt (‘Select Region or enter * for all Regions’,‘a’,‘Branchcode Hierarchy\Region’,multi,free)”
Parsing Failed.
Can you please suggest,What is the error in this ?
In the linked post it mentions the object won’t parse since it doesn’t reference a table.
Dave Rathbun (BOB member since 2002-06-06)