JQL & Jira Roadmaps: how to filter based on status of top level parent

Ben Birnbaum

We use Jira Advanced Roadmaps for our roadmap planning and I'm struggling with creating filters based on parent status rather than specifying a static Issue. First some background:

• We use three levels of issue types, Initiative>Epic>Story
• Initiatives are our top level roadmap item that we use to communicate our investments to broader audiences (ie, exec level view)
• We try to avoid having more than one initiative per product in progress at one time (ie, active development has started)
• I've created a couple dashboards for basic reporting and visualizations related to a specific initiatives, such as created/resolved, average story size, issue type breakdown, cycle times, etc
• Most of these dashboards a driven by about a dozen filters that use portfolioChildIssuesOf or Parent Link

Problem & Question

• I have to manually go update the Issue ID in each filter anytime we start a new initiative
• Is there a way to do something like "if parent initiative in In Progress, return its child issues". From there I could add other qualifiers like only To Do and In Progress stories, etc.

Tom Lister_fo1j4e

Hi @Ben Birnbaum 

You could try creating a filter equivalent to 'issueType = Initiative AND Status = "In Progress"'. Save that filter as ActiveInitiatives

Then apply it to the function e.g.

issuekey in portfolioChildIssuesOf("filter = ActiveInitiatives")

I haven't got scriptrunner on our cloud so I can't check this out, but many functions will take the filter clause as input