Discussion board where members can learn more about Qlik Sense Data Connectivity.
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
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
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.
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.
View solution in original post
See if this script helps.
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?