1 Reply Latest reply: Nov 10, 2011 2:31 AM by 885908 RSS

    IN condition for RSQL

    827953
      Hi Everyone,

      I have observed a behavior in IOP where if i ran an RSQL in IOP having IN Condition with its List values directly passed in the query itself it works fine. For e.g.

      Select Dest, Source, Usage From BOM Where Dest IN ('111','121')

      However if i try to do the same thing using parameters passed externally using ? IOP throws Parse Exception error. For e.g

      Select Dest, Source, Usage From BOM Where Dest IN (?,?)

      Has anyone tried using the IN condition in the RSQL parameters and tried passing the values from externally to it.

      Regards,

      Wes