JQL to get Stories linked to Epics of a specific Initiative

[Chander Inguva]

Is it possible to get all Stories tied to Epic given an Initiative.

I was able to get this by two separate queries 

query 1: Using Parent Link = "XYZ" i got Epics linked to an initiative

query 2: Using Epic Link = "ABC" i got stories linked to Epic.

How to achieve this in a single query.

P.S: We use Script Runner as well

Thank You

Chander

[Chander Inguva]

Well i figured it out how to get this using Script Runner

1. Save a filter which pulls all Epics of an Initiative (level higher than Epic) say "ListOfEpics" (the filter id for below filter was 22323)

issueFunction in hasLinks("is Epic of") AND "Parent Link" = PR-448

2. Using above query as a subquery, i could retrieve all stories involved in Epics

issueFunction in issuesInEpics("filter=22323")

Reference article

Hope this helps someone using Script Runner till Atlassian deploys a way to report against grand children for Portfolio issue types.

Feel free to correct my query or any thoughts in improving above method is appreciated.

Cheers

Chander

[Christopher Heritage]

Thank you for this! Awesome stuff. Based on your method, we figured out a way to use just one query.

issueFunction in issuesInEpics("'Parent Link' = XXX-##")

where XXX-## is your Initiative issue ID.

[Chander Inguva]

Glad that it helped you Christopher Heritage.

Cheers

Chander

[erika assis]

@Chander Inguva  this was beautiful! 

2. Using above query as a subquery, i could retrieve all stories involved in Epics

issueFunction in issuesInEpics("filter=22323")

[ALLDATA CM]

Thank you.  This was of great help

[Povilas Lazauskas]

That helped me.

Taking into account using Script Runner plugin, I actually used like:

issueFunction in issuesInEpics("filter = 'my filter which returns epics'")

I wonder if each filter has it's id, or in your example it was just numeric name of the filter?

filter=22323