Filter by parent, key, and due date

Question

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

Hannes Obweger - JXL for Jira · Answer

Hi @Renata Maciel

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.)

Best,

Hannes

LynnG · Answer

Have you tried issuekey in portfolioChildIssuesOf (ABC-123) where ABC-123 is the epic key?

or edit your query by adding quotes

(parent in (GQK-XXX, GQK-YYY, GQK-ZZZ) OR key in (GQK-XXX, GQK-YYY, GQK-ZZZ)) ORDER BY duedate, parent ASC