system
August 6, 2008, 1:30pm
#1
Hello !
i would like to do something in a query :
in my query, i have put a condition on an object “Region” but i would like the user to be able to select either all values using “%” character or select some values (one or more )
have you got a solution
thank you for helping me out
(and sorry for my poor english )
yaladin (BOB member since 2008-08-06)
system
August 6, 2008, 10:23pm
#2
Your universe designer will have to help you out on this.
Take a look at two entries from the Designer FAQ:
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?
Yes. Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt.
(@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or
enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR
('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales
Geography\Co…
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…
Anita Craig (BOB member since 2002-06-17)
system
August 7, 2008, 11:49am
#3
what a pity a user can’t do this without having to modify universe…
Thank you.
yaladin (BOB member since 2008-08-06)