Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 726

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 727

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 728

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 729
Mutliple Values For Prompts in PS Query | CompShack.com

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 || '%';