ALL LOV Prompts

[system]

I created an LOV that includes “ALL” as a choice. I created a filter to prompt and resolve the “ALL” choice however, every post I’ve seen about this requires the syntax:

@Select(INQUIRY\LAST NAME) IN @Prompt('Select last name:' ,'a','INQUIRY\LAST NAME',multi,free) OR 'ALL' in @Prompt('Select last name: ','a','INQUIRY\LAST NAME',multi,free)

This leads to 2 prompts being displayed for the same value. Is there any way to combine these into one prompt?

Thank you!

---

s_handel (BOB member since 2005-12-30)

[system]

Welcome to B B

Try this link, for more information:
This has been discussed many times…

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…

---

BO_Chief (BOB member since 2004-06-06)

[system]

I appreciate the input, but I already have it setup the way I’ve read about on the boards. I specifically need help determining if it can be changed to only prompt the user once or not. Thank you!

---

s_handel (BOB member since 2005-12-30)

[system]

There should be only one prompt displayed to user if the Label of the prompt is the same. Just make sure that the Label is the same.

---

salam (BOB member since 2005-01-27)

[system]

Hi,

the problem in your syntax is that you have one extra space at the end of the prompt name (after the “name:”).

So if you use this:

@Select(INQUIRY\LAST NAME) IN @Prompt('Select last name:','a','INQUIRY\LAST NAME',multi,free) OR 'ALL' in @Prompt('Select last name:','a','INQUIRY\LAST NAME',multi,free)

then you should be prompted only once 8)

Marek

---

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

[system]

Aha! Thanks so much for all the help. It was the extra space causing the problem. I’m glad it was something simple.

---

s_handel (BOB member since 2005-12-30)