JQL: add support for fetching all the results by way of pagination

[jvanegmond]

Issue Summary

The JQL integration returns only the first 50 issues. This is the default number of issues returned via JIRA REST API. A mechanism should be implemented where a query is executed multiple times to fetch subsequent issues from JIRA.

Steps to Reproduce

1. Configure JIRA integration
2. Create any JQL query which returns more than 50 issues
3. Execute the query

Expected: More than 50 issues returned.
Actual: Only 50 issues returned.

Technical details:

• Redash Version: 0.12.0+b2449
• Browser/OS: Ubuntu 16.4
• How did you install Redash: Provisioning script from https://redash.io/help-onpremise/setup/setting-up-redash-instance.html

[denisov-vlad]

You can set "maxResults" option to get more than 50 rows. It is not a bug, it's default JQL limitation.

[arikfr]

Merged #1721.

While @denisov-vlad is right that you can just specify this in a query, it looks like 1K is a reasonable limit.

[justmiles]

It doesn't look like the 1K bump resolves this issue. The API limits the results to 100 so setting maxResults above that is effectively ignored. To return more than 100 results, we would have to paginate through the API.

Could we re-open or should I create another issue to implement pagination?

[arikfr]

@justmiles I reopened this.