need some help on prompt

[MSTRJD]

I have a text prompt where the user is prompted to enter for values.

For example if the user enters a value 123,i get the WHERE clause in sql as "WHERE value='123'" and the reports works good.

but when the user enters multiple values seprated by comma for example like 123,546,769. the WHERE clause in the sql will be "WHERE value='123,546,768' and no records will be retrived.

The sql i am expecting is "WHERE value in ('123,'546','768')"

is it possible for user to enter multiple values at one time separated by comma in the prompts?

Thanks

 

[nlim]

if "value" is an attribute, I would recommend you let use an attribute qualification prompt instead. Users can enter one or many values...

 

[MSTRJD]

nlim,

Do you mean listing all the attribute elements in the prompt for users to select as many elements they wish?
if so, the problem is the response time.since the attribute elements are very larger ,it takes lot of time (5-10mins) to load all the attribute elements.
so in order to avoid this,i am trying to use text prompt where the users will enter the values.
incremental fetch was not so effective in my case.

please let me know if you know any idea to over come this.

thanks

 

[nlim]

what you are refering to in your post is prompt on attribute elements.

I was referring istead to attribute qualification. create a new prompt, and select "qualify on an attribute". Then follow the steps.

 

[MSTRJD]

nlim,

it works good.

thanks