JQL "ORDER BY Desc" place null at the highest order

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 7.2.6, 7.3.5, 8.20.14
    • Component/s: JQL
    • None
    • 7.02
    • 3
    • Severity 3 - Minor
    • 4

      Summary

      When running JQL ORDER BY Desc, JIRA places the issue with null value for that field at the highest order, instead of at the lower order

      Steps to Reproduce

      1. Having 3 issues with value for a custom field as 1, 2, and null
      2. Run JQL query: ORDER BY <cusom_field> Desc

      Expected Result

      JIRA should order the issues as follows:
      2
      1
      null

      Actual Result

      JIRA places the null value at the highest rank
      null
      2
      1

        1. jql.png
          jql.png
          138 kB

            Assignee:
            Unassigned
            Reporter:
            Aqqiela
            Votes:
            107 Vote for this issue
            Watchers:
            58 Start watching this issue

              Created:
              Updated: