Wanted an option "ALL" in LOV's which shows us at time of prompt

[Former Member]

Hi, i am getting problem while doing the following process. Can anyone plz help me to do this ?

When the List of values are populated for an object (web intelligence) in a prompt there are distinct values which are displayed .

For example for Object Year it would be 2001 , 2002, 2003 , where an end user can select single or multiple values.

We are looking for a value which will be displayed as u2018ALLu2019 in the lovu2019s and when selected will take all the values for the query.

Thanks.

[MariannevL]

You asked the same question in the WebI forum, see that post for more detail...

[|]

Basically I think there is not much need for this anymore with the optional prompt possibility,

but you can do this by changing the LOV query (SQL edititing) and adding a union to get the 'All' showing in there...

Good luck,

Marianne