Problem in @prompt using

[system]

Hi,

i have a requirement that i need to add"All" to an object . If he/she selects All then report has to display by considering all the values in the object. for this, i idi

edit object and add union select ‘…ALL’.
and in where clause

@Select(class\object) in  
@prompt('01.Enter value(s) for xxx:','A','class\object',Multi,Free,persistant,) 
OR ('...ALL') IN
 @prompt('01.Enter value(s) for xxxx:','A','class\object',Multi,Free,Persistent,{'...ALL'})

Parse OK. While i drag and drop the object in query panel and click Run / view button it is not responding. Even sql also giving parse ok.

Any one suggest me on this.

Regards
sunil.

---

sunil_ogl (BOB member since 2007-04-19)

[system]

Hi,

      Please check this link

FAQ: Designer

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…

Regards

[/url]

---

ay1224 (BOB member since 2007-07-30)

[system]

Sunil,

Did you try using the same prompt definition in both places? Like this:

@Select(class\object) in  
@prompt('01.Enter value(s) for xxxx:','A','class\object',Multi,Free,Persistent,{'...ALL'})
OR ('...ALL') IN 
@prompt('01.Enter value(s) for xxxx:','A','class\object',Multi,Free,Persistent,{'...ALL'})

One question for you: Why do you have the above code in the where clause of your object instead of as a condition object in the universe?

---

srividya.s (BOB member since 2006-10-28)

[system]

Check this FAQ.

---

Jansi (BOB member since 2008-05-12)