Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-81276

Provide an option for Confluence to display more than 1000 issues while using Jira Issue Macro

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • Macros - Jira Macros
    • None
    • 4
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      Issue Summary

      Jira Issue macro will only return a max of 1000 rows regardless of emptying the maximum Issues field (where it says it will return all rows if empty).

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Edit a Confluence page and insert Jira issue macro.
      2. Search for a Jira project which has more than 1000 issues in it and insert.
        • By default JIM allows only 1000 results through display options

      Expected Results :

      JIM to display more than 1000 issues which are returned by Jira. 

      Actual Results :

      Confluence does not allow to add a number which is more than 1000 

      Workaround

      This problem can be circumvented by raising API limits within Jira, and utilizing Jira gadgets rather than the native macro within Confluence. This allows Jira to render the gadgets directly, instead of providing the raw data for Confluence to interpret. Both steps must be taken, as the default issue limit for Jira's API is 1000 issues— and this value is separately hard-coded in the native Confluence issue macro.

      This workaround will raise limits globally for all users and services that have API or export access. Larger requests have the potential to impact the performance of the instance or cause an outage— so it's important to use a limit that balances usability with the level of risk tolerance that is right for your organization.

      To enable the workaround:

      1. In Jira, navigate to Jira Administration > System > General Configuration > Advanced Settings.
      2. Change the following keys to the issue limit that you've decided on. Make sure to click the Update button to the right of each key after you've edited it.
        • jira.search.views.default.max
        • jira.search.views.max.limit
        • jira.search.stable.max.results
      3. In the <JIRA HOME>/jira-config.properties file, add the following line (or modify the value if the property is already present). If this file doesn't already exist, create it.
        • jira.table.gadget.max.rows = <MAX_ISSUE_LIMIT_HERE>
      4. Restart Jira.
      5. In Confluence, navigate to General Configuration > External Gadgets > Gadget Feeds.
      6. Enter the base URL for Jira in the Gadget Feed URL field, and click Add.
      7. Restart Confluence.

      After the workaround is complete, a few new macros will show up in the editor. The Filter Results macro provides similar functionality to the native issue macro, and will now be able to display issues up to the limit we just configured.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              e4b6edf29732 Gopi Annepaka
              Votes:
              9 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated: