"ORDER BY" clause in JQL changes the sorting if the options for the specified field are disabled.

XMLWordPrintable

    • 3
    • 1

      Summary

      When using JQL with the ORDER BY clause and a custom field of type "Select List (single choice)", sorting behavior depends on the field options' status. If the field's options are disabled, the results containing those options will be placed at the bottom of the list. However, if the options are enabled, the results will be sorted correctly.

      Steps to reproduce

       

      1. Run a JQL statement ordering by a  "Select List " custom field
      2. The result is a list of work items with a sequential order in the "Select List (single choice)".
      3. Access Settings -> Work items -> Fields -> Context and default values
      4. From the available list, disable an option
      5. Run the previous JQL

      Actual results

      Disabling an option in the "Select List (single choice)" field type affects sorting when using ORDER BY.

      Expected results

      Even when the "Select List (single choice)" field type has options disabled, it should still sort the work items in the same manner as if they were enabled.

              Assignee:
              Unassigned
              Reporter:
              Ramiro Perez Zamorano (Inactive)
              Votes:
              23 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: