Query: Showing epics linked to features in a different project - how to also show epic children?

Alan Foster_clpyzr

Hello, I have feature in project FEATUREPROJECT

Multiple teams have Epics which are linked to FEATURE as parent link. Each team has their Epics in their own, separate, projects.

I can get a query to show the Features and Epics: 

issueFunction in portfolioChildrenOf("issuetype = Feature and project ='FEATUREPROJECT'")  OR project = "FEATUREPROJECT"

What do I need to add to the query to also show the hierarchy of issues beneath those epics?

 

FEATUREPROJECT is simply a house for feature level issues that impact multiple teams, want to roll it all up into a Portfolio Plan view. 

 

Use of Plugin - highly doubtful and would take months to get someone approve... you know how it is.

 

Thanks for your help

Alan

Ste Wright

Hi @Alan Foster 

This is possible to do - it looks like you have an app already if you're utilising "issueFunction" - likely ScriptRunner or similar.

See if this works for you:

project = ABC OR issueFunction in portfolioChildrenOf("issuetype = Feature AND project = ABC") OR issueFunction in issuesInEpics("issueFunction in portfolioChildrenOf('issuetype = Feature AND project = ABC')")

^ This searches for issues in project ABC, the Epics under the Features and then in turn, the issues within those Epics. You could create this as two filters if you prefer, and nestle the first filter for Epics into the second.

I would suggest using the nestled approach if you take this further, as you could also add in issueFunction in subtasksOf() if you want the hierarchical layer below the stories, tasks, etc. Or if you wanted this in one filter it might look something like...

issueFunction in portfolioChildrenOf("issuetype = Feature and project = ABC") OR issueFunction in issuesInEpics("issueFunction in portfolioChildrenOf(\"issuetype = Feature and project = ABC\")") OR issueFunction in subtasksOf("issueFunction in issuesInEpics('issueFunction in portfolioChildrenOf(\"issuetype = Feature and project = ABC\")')")

...although depending on your use case - if these issues are to be shown in a Portfolio Plan - you could consider just searching for the Feature Project and all corresponding projects which house the Epics, etc. Unless these projects have lots of issues irrelevant to the Features, this would provide all needed issues and Portfolio would put them into the hierarchical structure you require.

Ste