How to pull the whole table of Worklog using the Qlik JIRA Connector (Qlik Web Connectors)?

[pablomind]

Hello,

I've successfully pulled the Issue and Projects Table using the Qlik JIRA Connector but when im trying to get the Worklog table it only does for an specific issue but i want all the worklogs of all issues at once. Is this even possible with this connector?

Thank you in advance,

Pablo

[chrisbrain · Accepted solution]

I think you would have to create a for/next loop in your Qlik script which loops through every issue ID and runs the Worklog table once for each.

[pablomind]

Thank you very much this solution worked perfectly!

[chrisbrain]

Great!

[juraj_misina]

Hello Chris,

maybe a bit off topic, but is there any guesstimate if/when will the Jira connector come out from Beta? Thanks.

Juraj

[victorbertoldozg]

Coud you post an exemple of your script with a for condition?

Thank

Victor

[ajayvermaida]

how to get the full table of sprint with Jira web connector or rest API ?

[gvalenti]

Hi, this solution works fine. The problem is the number of calls from Qlik to Jira. For example, 50 projects, with 100 issues, generate 5000 calls from qlik sense to the JIRA server and the result is 5000 logins which burden the JIRA server. Is there a solution that does not involve such a large number of calls to the server?