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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Low
    • Resolution: Duplicate
    • 6.8.0, 6.7.2
    • None
    • 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

          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: