You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am in need of a filter that can sort activities contained in multiple epics by due date, taking into account if they belong to the same epic. However, I am having difficulty because the filter currently sorts everything by due date only, without considering if the activities are from the same epic or not:
e.g. parent in (GQK-XXX, GQK-YYY, GQK-ZZZ) OR key in (GQK-XXX, GQK-YYY, GQK-ZZZ) ORDER BY duedate, parent ASC
welcome to the community!
Assuming that you are able to query the correct set of issues, I think you need to turn around the ORDER BY clause, to
ORDER BY parent, duedate ASC
... so it will *first* order by parent, and only within the same parent, order by due date - which I believe is what you want?
(Also note that Atlassian is making a few changes to how issue hierarchies work in Jira, so it may be that you have to ORDER BY "Epic Link" instead of parent... just in case that the above change doesn't work.)