title: PS Query - multiple values within a single prompt
body: <p>In PeopleSoft Query, I want to allow users to choose multiple values within a single prompt. I work at a higher education institution, so I'll give a real time example.  In the Faculty of Science (the field is GRP), there are 8 departments - Biology, Chemistry, Computer Science, etc.(this field is an ORG) .  In the prompt for ORG, I want the user, within that single prompt, to choose multiple ORG values. So far, the only solution I have come across is to create multiple prompts and allow the user to choose each ORG separately.  Is this even possible?  I did research earlier, and someone 7 years ago posted a solution, but later on someone else indicated that this only works for earlier tools versions.  I tried to run the solution and it failed (as predicted).</p>
  
  <p>Has anyone figured out a way to do it in PS Query?  The only other recommendation that I have received is to write the report in BI Publisher.</p>