Jira Issue Macro repeats last requested page of issue results from Jira (OnPrem and Cloud)

XMLWordPrintable

    • 5
    • Minor

      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

      1. Set up an Application link between Confluence Cloud and Jira (cloud or OnPrem)
      2. Ensure that you have a JQL query that returns more than 100 results from Jira
      3. 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
      4. save the macro and publish the page
      5. 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.

            Assignee:
            Nick Yang
            Reporter:
            Jared Long
            Votes:
            7 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved: