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

[a_mullick]

Hi  Ricardo,

See if this script helps.

Thanks,

Azam

Added: sorry, I didn't appreciate that you're working with QlikSense, so don't know if this will work. Is the script editor the same?

[Ricardo_Gerhard · Accepted solution]

The problem was identified: the PHP web site have some requirements to request data and sometimes must be created a loop process (for each...) to recover all problems.