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]

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

[Ben Birnbaum]

i'll give it a try, thanks @Tom Lister !

[Ben Birnbaum]

One other side question, @Tom Lister . I noticed you didnt include spaces in your hypothetical filter naming. Do you find that beneficial beyond just being easier to see in dropdowns, etc?

[Tom Lister]

Ha Just a programming habit

[denver.currie]

Hi Ben / Tom 

Did you make any progress on this?  I am (conveniently) having the exact same problem however when I try

issuekey in portfolioChildIssuesOf("filter = ActiveInitiatives")

I get the following returned

Unable to find an issue with matching key filter = ActiveInitiatives


I think this might be because we are using Jira Cloud and it only supports single keys in portfolioChildIssuesOf

[Tom Lister]

It might be the case that cloud is different

The documentation doesn't state JQL clauses don't work but it only shows examples of direct epic keys

https://confluence.atlassian.com/jiraportfoliocloud/searching-for-portfolio-for-jira-custom-fields-in-jql-941619014.html

https://docs.adaptavist.com/sfjcl/how-can-i-search-for-porftolio-issue-links-50331682.html

[denver.currie]

Thank you.