Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-72847

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

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • Search - Frontend
    • None
    • 18
    • 3
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    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. According to the documentation from PostgreSQL 8.3.23 the NULLS FIRST is the default for DESC order, but is configurable.

      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

      Actual Result

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

      Suggestion

      JIRA could order the issues as follows:
      2
      1
      null

      Attachments

        1. jql.png
          jql.png
          138 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              azuhra Aqqiela
              Votes:
              120 Vote for this issue
              Watchers:
              43 Start watching this issue

              Dates

                Created:
                Updated: