need a report with all the list of child issues

[Santhana Raj Maharajan]

Hallo Community team,

 Please help on the following

-> we need a query that should report the parent & all its child...

e.g. Epic & all the stories underneath

[Prosper Agwegiokhe]

Hi @Santhana Raj Maharajan ,

I’m Prosper, a support engineer at Appfire, and I’m here to help you.
Unfortunately, natively, you’ll not be able to do it dynamically. However, in the app my team works, JQL Search Extensions for Jira, you can use the query below to get your desired results:

issue in epicsOfChildrenInQuery("") and key = 'EpicKey' OR issue in childrenOfIssuesInQuery("key = 'EpicKey'")

Please contact our support if you have any other questions about this query.
We’ll be happy to help you!

Best regards.

[John Funk]

Hi Santhana,

Try this: parent = ABC-123

where ABC-123 is the issue key of the Epic. 

[Santhana Raj Maharajan]

Hallo John,

Thanks for your response, but my expectation is as below

ABC-123 -> CDE-1, CDE-2, CD-3

where ABC is epic, and CDEs are stories. In this case we need the 3 stories list in one column and corresponding epic in another column

[John Funk]

You will need an add-on like ScriptRunner to be able to do that.