Predefining Available Selections For Webi Prompt

[former_member516039]

I have created a Query Filter prompt in the Query Panel. I want the selections available to the user to be specific values from the underlying field. I don't want to default certain values to the prompt, but I want to limit which values from the field show up as usable options. I thought there was a way to do this but now I'm getting confused and can't seem to get a list created.

[amitrathi239]

in the filter condition define the static LOV's..

Tablename.col1 IN  @Prompt('Enter value(s) ','A',{'X','Y'},Multi,Constrained,Not_Persistent,,User:-1)

[former_member516039]

Can I do that in the Webi Query Panel? I can't do it in the Universe or the SQL because every time I use the Multi parameter I get errors when more than one value is selected.

[former_member516039]

Would it be possible to use a subquery where I first limit the values returned by that field and then the main query uses the a prompt based on that list? Or can I just tell the Webi prompt that the values I need to provide are the only values that the user can select?

[jyothirmayee_s]

Hi,

What is the source for Webi, if it is Universe you can limit the list of values as static.

In WebI, you define the values in Prompt properties within query panel and check the option

"Select Only from the List".

Thanks,

Jothi

[former_member516039]

I tried that but that lists all values from the field and not just the ones I want to limit them to.