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

JQL with multiple "order by" including "parent" not work well

XMLWordPrintable

      Issue Summary

      In JQL Query, the user can use some Order BY separated by ",".
      But if "parent" is added as "order by parent", key is sorted "DESC" and 2nd and after orders do not work as expected.

      Steps to Reproduce

      1. Create Company-managed project
      2. add Parent issue types(example "Initiative and Epic", "Epic and Story", "Task and Subtask")
      3. create issues, add "Parent" in some issues.
      4. Open JQL and add "order by parent" as below.

      JQL example

      project = "Project name" and issuetype in (Initiative, epic) order by parent,key ASC

      "key" should be sorted "ASC", but key is sorted "DESC". And without "ASC", it sorted "DESC" too.
      not only "key", "summary" and other field not work if "parent" is included in order.

      Expected Results

      multiple orders should work.

      • order by summary and key, it works well.

      Actual Results

      multiple orders do not work well, if "order by" includes parent.

      • 2nd order by "key", is not sorted as written.
      • If without "key", it shows the same results as upper image.

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

        1. not_include_parent.png
          not_include_parent.png
          70 kB
        2. parent_ASC.png
          parent_ASC.png
          70 kB
        3. parent_DESC.png
          parent_DESC.png
          70 kB

              Unassigned Unassigned
              38f0fdb790c2 K. Ariga
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated: