Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-61852

ORDER BY is not Respected in Jira Filter Issue Macro When Using Saved Filter

    XMLWordPrintable

Details

    Description

      Summary

      When using a Saved Jira Filter in the Jira Issue/Filter Macro is not respecting the ORDER BY clause that is saved

      Steps to Reproduce

      1. In Jira Create and Save a Filter
      2. On a Confluence page, add a JIRA Issue/Filter that references the Saved Filter you've created (either "Filter = 'Name of filter'" or "Filter = ID")
      3. Use the Table display option

      Expected Results

      Confluence displays a list of issues using the defined order

      Actual Results

      If the Saved Filter Name or ID is used in the JIRA Issue/Filter, the ORDER BY does not appear to be used; based on testing, it appears that the Issues are sorted by Issue Key and/or Created Date descending.

      Here are a few examples with different JQL used

      Notes

      The JQL and Saved Filters display correctly in Jira

      Workaround

      • View the saved filter in Jira

      Attachments

        1. Example01.png
          Example01.png
          286 kB
        2. Example02.png
          Example02.png
          297 kB

        Issue Links

          Activity

            People

              802848781776 Nick Yang
              scranford Shawn C
              Votes:
              94 Vote for this issue
              Watchers:
              75 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: