topic Re: Multiple Values on Where clause on Qlik Rest Connector in Connectivity & Data Prep

Multiple Values on Where clause on Qlik Rest Connector

Ricardo_Gerhard — Wed, 15 Mar 2017 14:50:05 GMT

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

Re: Multiple Values on Where clause on Qlik Rest Connector

a_mullick — Thu, 16 Mar 2017 08:49:41 GMT

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?

Re: Multiple Values on Where clause on Qlik Rest Connector

Ricardo_Gerhard — Thu, 16 Mar 2017 11:41:17 GMT

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.