2 Replies Latest reply: Mar 11, 2013 9:18 PM by User9545618-Oracle RSS

    Matching against a multi-select list

      Hello all,

      I have a 'Select List' widget (P_FILTER) which I have set to return multiple values.

      In my report region, I have something like this

      Select A from B where B.Col_1 IN upper(:P_FILTER)

      When user selects only 1 value, the report is correct but if user selects more than 1 value (e.g. 2), the report does not return any rows. How do I get the report to recognize the multiple values returned by the LOV?