\uD83E\uDD14 Problem
A hierarchy report was created following the Epic - Task - Sub-task relationship. The report should show the issues following that order, but some sub-tasks are shown twice or out of place in the report.
\uD83C\uDF31 Solution
Review the fields and any filter or JQL applied to it. In this case the customer used the following fields and JQL:
Issue Type
Issue Key
Assignee
Some other Custom Fields.
JQL used: Project = REQ AND statusCategory != "Done" and id != "REQ883" AND (labels in ("bp-high", "ProblemStatement") OR component in ("Game)) order by [Projected Into QA Date] ASC
2. Remove order or filters applied to the report, and check for the display of the report. In the case described, the user was altering the display of the report by adding a “order by” clause in the JQL.
Hierarchy reports are not meant for sorting