7 Replies Latest reply: May 6, 2014 10:28 PM by AlexAA RSS

    Interactive Report "IN" operator doesn't work with commas

    Steve.1234555-Oracle

      Hello,

       

      I'm using an APEX interactive report and I need to filter one of the columns by a couple values.  I'm using the Column IN operator.  However one of the strings I'm searching for has a comma in it.  The IR treats this as a delimiter and doesn't find the value. For example, I want to filter to values:

      Oracle Canada ULC

      Oracle America, Inc.

       

      The expression Operating Unit IN in the IR equals 'Oracle Canada ULC,Oracle America, Inc.'.  It only finds rows with "Oracle Canada ULC".  It seems to think "Oracle America" is the second search value and " Inc." is the third, and finds nothing for them.

       

      Is there a way to escape the comma in "Oracle America, Inc." so it treats the whole string as one value to search for?

       

       

      Thanks,

      Steve