Details
-
Bug
-
Resolution: Fixed
-
High
-
5
-
Minor
-
Description
Issue Summary
This is affecting application between the below environments:
Cloud -> Cloud- Cloud -> OnPrem/DC
When the Jira Issue Macro is used to get more than 100 results, the last page requested will be repeated at the end of the list of issues displayed in the macro. This also breaks story points calculation.
Steps to Reproduce
- Set up an Application link between Confluence Cloud and Jira (cloud or OnPrem)
- Ensure that you have a JQL query that returns more than 100 results from Jira
- In Confluence, create a Jira issue macro using the large query JQL and set the display options to show 500 max results. NOTE: In my testing, I also only show the issue key column
- save the macro and publish the page
- View the results of the macro
Expected Results
The macro returns the list same as a JQL search on the Jira server
Actual Results
The First 100 results will show normally.
The last page of 100 or fewer results will show up twice at the end of the list.
Workaround
In some cases, you can work around the issue by adding an ORDER BY clause to the end of the query. e.g. ORDER BY key DESC
NOTE: Story points calculation is not corrected when using this workaround.