2 Replies Latest reply on Jan 22, 2013 9:27 PM by NewApexCoder

    Query Report Using Shuttle List


      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!