Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Employee
Employee

Multiple Values on Where clause on Qlik Rest Connector

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

Ricardo Gerhard
OEM Solution Architect
LATAM
1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Multiple Values on Where clause on Qlik Rest Connector

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.

Ricardo Gerhard
OEM Solution Architect
LATAM

View solution in original post

2 Replies
Highlighted
a_mullick
Contributor III

Re: Multiple Values on Where clause on Qlik Rest Connector

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?

Highlighted
Employee
Employee

Re: Multiple Values on Where clause on Qlik Rest Connector

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.

Ricardo Gerhard
OEM Solution Architect
LATAM

View solution in original post