Create a Plan that shows all items of Epics, linked to any of the project initiatives

[aleksi-p]

Hi there

We use Jira Advanced Roadmaps Data Center and added one more hierarchy-level above the Epics - which is an Initiative. For all Initaitives, we have a separate project (let's call it "INV"). We also have several other Jira- Projects per product, where the teams can create their own initiatives.

I want to have a plan in Jira Advanced Roadmaps, where I see all items (Epics, Stories, Tasks) etc. of Epics linked to any of the initiatives of the project "INV". Becuase product-projects can have their own initaitives, I don't want to show those.

The following JQL, it returns "everything" for all Jira projects. 

issueFunction in linkedIssuesOfAllRecursive("project in ('INV')")

The following JQL however, does not return all Epics and Stories and Tasks. Some are missing.

issueFunction in linkedIssuesOfAll("issueFunction in portfolioChildrenOf('project = INV')")

Any ideas? Cheers

[aleksi-p · Accepted solution]

Found the solution :-) Need to split it the task in two queries.
issuesInEpics returns only the issues, therfore get all the issues from the Epics linked to the INV-Initiatives, and then get the iniatives themselfes from the INV project.

issueFunction in issuesInEpics("issueFunction in portfolioChildrenOf('project = INV')") OR issueFunction in portfolioChildrenOf('project = INV')