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

In JQL, when used ORDER BY parent may return duplicates

XMLWordPrintable

      Issue Summary

      When you are making a JQL query with orderby clause which includes parent, we are seeing duplicates to be returned in the results.

      Steps to Reproduce

      1. Use a JQL to query for list of issues in the project and sort by parent, you will see the results are getting duplicated.
      2. When making a JQL query like below gives a result like 10(say)
      Project = TEST ORDER BY type ASC
      1. Use the JQL like below, the result shows 14(some issues are duplicated not all)
      Project = TEST ORDER BY type ASC, parent DESC

      Expected Results

      No duplication should be seen and must match the results for both JQL queries.

      Actual Results

      The actual results are more than expected.

      Workaround

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

          Form Name

            [JRACLOUD-78339] In JQL, when used ORDER BY parent may return duplicates

            Matthew Hunter added a comment -
            Atlassian Update - February 2, 2023

            Hi everyone,

            Thank you for previously raising this bug and bringing it to our attention.

            Within our company roadmap and work capacity, we try to address or review each bug request but admit that not each one will be resolved. To continue the culture of being honest and open, we are closing this bug to focus on our upcoming roadmap for all Jira users.

            As we continue to roll out features we do look at requests made by our users and if you feel like this bug is still impacting your team please let us know.

            Thank you again for providing valuable feedback to our team!
            Jira Cloud team

            Matthew Hunter added a comment - Atlassian Update - February 2, 2023 Hi everyone, Thank you for previously raising this bug and bringing it to our attention. Within our company roadmap and work capacity, we try to address or review each bug request but admit that not each one will be resolved. To continue the culture of being honest and open, we are closing this bug to focus on our upcoming roadmap for all Jira users. As we continue to roll out features we do look at requests made by our users and if you feel like this bug is still impacting your team please let us know. Thank you again for providing valuable feedback to our team! Jira Cloud team

              Unassigned Unassigned
              8f30444007a4 Bernice
              Affected customers:
              1 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: