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

Details

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

    Description

      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

      Attachments

        1. jql.png
          jql.png
          138 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              azuhra Aqqiela
              Votes:
              97 Vote for this issue
              Watchers:
              50 Start watching this issue

              Dates

                Created:
                Updated: