Qlik Community

Connectivity & Data Prep

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ricardo_Gerhard
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
Ricardo_Gerhard
Employee
Employee
Author

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
a_mullick
Creator III
Creator III

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
Employee
Employee
Author

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