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

Sorting JIRA issues macro with pre-sorted JQL results in permissions error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • 6.7.2, 6.8.0
    • Integrations - Jira
    • None

    Description

      Summary

      When JQL in JIRA Issues Macro includes sorting on a field of two words or more (e.g. Request Participates or Due Date), sorting in column view fails with a permissions error.

      JIRA project doesn't exist or you don't have permission to view it.

      Environment

      • JIRA 7.5
      • Confluence 6.7.2

      Steps to Reproduce

      1. Create page in Confluence, insert JIRA issues macro, use test JQL: 
        project = TEST ORDER BY "Request participants" ASC
      2. Create another JIRA issues macro using this test JQL: 
        project = TEST ORDER BY "Key" ASC
      3. Save page.
      4. Sort each result separately using column sorting.

      Expected Results

      Sorting should occur naturally. When you pre-sort in JQL using "Key" it works. You can even remove the sort and it still works.

      Actual Results

      First JQL that uses Request Participants results in:

      Workaround

      Do not include sort in JQL

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-43586 Can't sort column if the same one is being mentioned in a ORDER BY clause - JQL - Jira Issue Macro

          • Low - Low priority issues
          • Long Term Backlog
          is cloned from

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-53559 Sorting JIRA issues macro with pre-sorted JQL results in permissions error

          • Low - Low priority issues
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-54029 JIRA Issues Macro does not sort when the up and down buttons are clicked

          • Low - Low priority issues
          • Closed
          relates to

          Suggestion - CONFSERVER-35323 Add ability to predefine ordering of JIRA Issues Macro/respect filter order by

          • Gathering Interest

          Activity

            People

              nbhawnani Niraj Bhawnani
              smackie@atlassian.com Shannon S
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: