Skip to Content

Predefining Available Selections For Webi Prompt

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 15, 2016 at 03:04 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 15, 2016 at 03:05 PM

    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)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.