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

3 replies [Last post]
Guest's picture
Guest

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
Guest
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

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

Did the answer work for anyone?

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

WHERE :1 LIKE '%' || HRS_PERSON_ID || '%';