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

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

      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

        1. Screen Shot 2016-02-24 at 16.17.46.jpg
          Screen Shot 2016-02-24 at 16.17.46.jpg
          23 kB

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

                Created:
                Updated:
                Resolved: