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
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")
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.
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?
We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...