This discussion is archived
1 Reply Latest reply: Jan 22, 2013 1:13 PM by jariola RSS

Report using Shuttle List

NewApexCoder Newbie
Currently Being Moderated
Greetings

I am using Apex Version 4.2

At first, I had created an item P31_JOB_CATEGORY that was a radio button. Upon selecting a value for the radio button, a report was generated. The query is as follows
 select a, b, c
from Table A
where A.Job_Category = :P31_JOB_CATEGORY
This gave me the desired report. Now I want to change the radio button to a shuttle list so multiple values can be selected for the job category and generate a the report accordingly. Instead of one value, I can have 2, 3, or all. How would I alter my query to change this? would I have to use an array. I was thinking some type of "Where....In.." clause.

Thanks in advance!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points