How to query stories where the epic is linked to another epic?!

[Sebastian Kimpeler]

Hey there,

I am trying to find a query for the following scenario:

1) Epic 1 - contains Epic 2, Epic 3 etc.. - Epic 2, Epic 3 etc. contain the actual stories

2) Epic 4 - contains Epic 5, Epic 6 etc.. - Epic 5, Epic 6 etc. contain the actual stories

What I would like to do is to report who much work I've spend on the 'parent epics' (Epic 1 & Epic 4) which means I need the stories for the child epics but still knowing to what parent they belong...

Hope this makes sense haha and thanks for any help!

[Bill Sheboy · Accepted solution]

Hi @Sebastian Kimpeler  -- Welcome to the Atlassian Community!

First thing: what version of Jira Cloud are you using: free, standard, premier, etc.?

I ask, because normally it is not possible for an Epic to contain another epic (by epic link).  Are you perhaps using the issue link field to do this?

Regardless of those issues, in general out-of-the-box Jira cannot do the nested queries you mention through multiple levels: give me this epic, and its "child epics" and their children...  To do so you would need a marketplace scripting addon product, or to perform this check manually by exporting the data and then joining it by your links.

Best regards,

Bill