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

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

XMLWordPrintable

      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.2.0-OD-02-009
      • Confluence 6.0.0-OD-2016.08.1-0001

      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

        1. jira sorting.PNG
          jira sorting.PNG
          73 kB
        2. Screen Shot 2016-02-24 at 16.17.46.jpg
          Screen Shot 2016-02-24 at 16.17.46.jpg
          23 kB

              Unassigned Unassigned
              smackie@atlassian.com Shannon S
              Votes:
              28 Vote for this issue
              Watchers:
              31 Start watching this issue

                Created:
                Updated:
                Resolved: