Project "View Issues" for priority has duplicate sorting causing error

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: Archived Jira Cloud, 7.2.1, 7.7.0, 7.7.1, 7.10.0
    • Component/s: JQL
    • 7.02
    • 10
    • Severity 3 - Minor
    • 2

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      • Project "View Issues" for priority has duplicate sorting causing error.
      project = 11400 AND resolution = Unresolved ORDER BY priority DESC, priority DESC, key ASC

      Steps to reproduce

      1. Go to project summary
      2. Switch the view to Statistics if necessary
      3. Under Unresolved: By Priority section, click on View Issues

         

        Expected result

      • JIRA returns search result with the specified sorting.

      Current result

      • JIRA will throw error The sort field 'priority' is referenced multiple times in the JQL sort

      Workaround

      * Edit the JQL manually by removing the duplicate sorting priority DESC, and rerun the search.

        1. image-2018-02-09-20-05-01-051.png
          image-2018-02-09-20-05-01-051.png
          116 kB
        2. screenshot-1.png
          screenshot-1.png
          16 kB

            Assignee:
            Unassigned
            Reporter:
            Fahd (Inactive)
            Votes:
            30 Vote for this issue
            Watchers:
            31 Start watching this issue

              Created:
              Updated: