Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-65848

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 7.2.6, 7.3.5, 8.20.14
    • JQL
    • None

      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

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

                Created:
                Updated: