It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

1 answer

1 accepted

1 vote
Answer accepted

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

Hi Stephen,

Thank you for such a comprehensive reply. I will try this over the weekend!  I had started to build a new query to pull in each project, but as you say there are a number of issues in each which do not correspond to the feature set, so folks may not like it. 

Thank you very much and have a great weekend.

 

Alan

No worries - let us know if this works and if not, happy to help further!

Ste

Like Alan Foster likes this

I will, thank you again sir!

 

Alan

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you