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!
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.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events