You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Mutliple Values For Prompts in PS Query

1 reply [Last post]
Guest's picture

I'm trying to build an 'In list' prompt HRS_PERSON_ID so that users can enter multiple HRS_PERSON_ID separated by a comma. is this possible in a PS query

Guest's picture
Re: Mutliple Values For Prompts in PS Query

Try this expression
(:3 = '%'
OR (0 <> INSTR(',' || :3 || ',' , ',' || RTRIM( A.DEPTID) || ',')))

Your prompt field should be a description field that can hold more characters.
User can enter the prompt values separated by commas.

% will work when user did not enter any value in the prompt

Post new comment

The question below is to prevent automated spam submissions.
4 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.