All in prompt LOV

[system]

Hi All,

I want to know how the below mentioned thing can be implemented and how it works.

Issue#1 : I want ‘All’ to come in prompt LOV.
Issue#2: When I select ‘All’ in prompt,behind the scene how does it select all the values of that particular LOV.
How exactly universe understand that when user select ‘All’,it need to pass all the LOV values or what changes it makes at the query level.
I’m curios to know how does it happen ?

Please help in understanding this issue.

Thank for your time.

Regards,

Arun

---

binnu23 (BOB member since 2010-05-21)

[MarkP]

Please read through the Designer FAQ:

FAQ: Designer

Designer FAQ How should I impose a WHERE clause in my object(s) in the universe? 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? Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? I’ve deleted a universe and I’m in a mess! What do I do now? How do I migrate universes between repositories? How do I create cascading or nested prompts? What is an isolated join and how do I f…

[system]

Hi Mark,

In that post,resolution for my Issue#1 is given.I’ll try to implement that but still I’m searching answer for my second issue.

---

binnu23 (BOB member since 2010-05-21)

[MarkP]

In effect it makes every row valid for selection.

Your query will have one of the conditions saying
table.column = ‘ALL’
or ‘ALL’ = ‘ALL’

Obviously ‘ALL’=‘ALL’ so all rows are valid for selection.

[system]

Hi,

@aruncser

…but still I’m searching answer for my second issue.

That’s another FAQ entry:

FAQ: Designer

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…

---

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