2 Replies Latest reply: Mar 16, 2017 7:41 AM by Ricardo Gerhard RSS

    Multiple Values on Where clause on Qlik Rest Connector

    Ricardo Gerhard

      Hello guys,

          I need to make a query by Qlik Rest Connector, CSV format, where will be queried some accounts / ids, something like the example below:
      Select

        *

      from table

      where field in (v1, v2, v3 ... vn)
          However, I have only identified that it is possible to query by sending one value each time, needing a loop procedure to get all results (slow), as below:
      Select

        *

      from table

      where field = v1
          Can anyone tell me if there is any way to do this or have an example to share? This clause is not commented in the Qlik documentation.


      Regards,

      Ricardo