1 Reply Latest reply on Aug 22, 2013 5:52 PM by Mike Kutz

    IR does not recognize the application item content correctly

    Eva E

      Hi,

       

      I have an application item that receives a web service result. This result is like 'MARIA','JOSE','JESUS'. I'm using this string into the parameters of the interactive report, but this is not recognized. I'm showing the content of the application item into a pl sql region and the content is 'MARIA','JOSE','JESUS', when I include this application item into the query, the IR shows me 'MARIA','JOSE','JESUS'

       

      How can i solve it

       

      Regards,

       

      Eve

        • 1. Re: IR does not recognize the application item content correctly
          Mike Kutz

          This is the infamous "Varring IN list" problem.

          It is an SQL problem, not an APEX problem.

           

          Take a look at this:

          The Tom Kyte Blog: Varying in lists...

           

          You'll also need to remove the single quotes from the string... I haven't tried the below..

          with data
          as
          (
            select
            trim( substr (txt,
            instr (txt, ',', 1, level ) + 1,
            instr (txt, ',', 1, level+1)
            - instr (txt, ',', 1, level) -1 ) )
            as token
            from (select ','|| REPLACE( :txt, '''', '' ) ||',' txt
            from dual)
            connect by level <=
            length( REPLACE(:txt,'''','') )-length(replace( REPLACE(:txt, '''', '') ,',',''))+1
          )
          select *
          from all_users
          where username in (select * from data)