Is there any possibility to pull all child issues from a parent by using JQL into excel?

[mhari.krishna]

While i am trying to export all issues into excel report from parent issue by using JQL, from that to pull all child issues from the parent link.
Can you please help me out how I can solve this issue? Any suggestions would be helpful.

Thanks.

[Jack Brickey]

Hi @mhari.krishna ,

please help me better understand your use case. Are you saying that you have a list of parents and you wish to find all children associated with those parents? If so the following JQL might help.

parent in (a,b,c,d...)

[Kalyan Sattaluri]

Your requirement is not clear, but I am guessing you want list of parent issues and their children in excel.. If so, you need 2 filters / JQL..

But you should look into "Importing Jira data into Excel directly" in the forums..

Essentially, you create 2 filters, 1 for your list of parents, 1 for children of parents.

Then in excel, you point to the CSV export URL to import both filters into excel and using power query, you can merge or develop your reports. This is automated so you can refresh data whenever you need it. You also can point to REST API instead of CSV export URL option.