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. Screen Shot 2016-02-24 at 16.17.46.jpg
          23 kB
          Shannon S
        2. jira sorting.PNG
          73 kB
          Oksana Bodnar

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

              Created:
              Updated:
              Resolved: