how to display "ALL" in LOV

[system]

dudes,

i have a requirment. MY month number object contains LOV’s like {1,2,3,…,12}. so my user wants me to display some label named “ALL” also under the lov, by clicking on which all the month_numbers from 1 to 12 shud get selected.

At present the user types “ALL” because of which all the lovs get selected.

so, can you people help me how to make that label “ALL” to get displayed under the list of lov’s under mi object??thus allowing mi end user to just select dat label instead of typing??

---

s_v21 (BOB member since 2007-01-30)

[system]

This is an FAQ in the Semantic Layer forum:

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…

---

Namlemez (BOB member since 2005-03-14)

[system]

Hi,

Please find the attached file for solution

Thank you

Upendar T
ALL VALUES.zip (219.0 KB)

---

upendar_tulluru (BOB member since 2006-08-05)