Advanced Roadmaps Issues from filter JQL help

Question

I'm working on an Advanced Roadmaps plan, and need to accomplish the following:

All Epics (from all projects) based on a specific criteria (due dates between a start and end date) AND all the tickets assigned to those Epics.

I can write a JQL query that returns the Epics I need, but when I use that filter as the issue source in Advanced Roadmaps ONLY the Epics appear and not the tickets assigned to those Epics.

Is there a setting I'm missing or does the issue source filter have to include all those tickets as well?

Any help would be greatly appreciated.

Daniel Turczanski - JQL Search Extensions · Answer

Hi @Sam Gerzon

It's not possible with standard JQL and it sounds like you need a JQL extensions app.

I described how our app can help with sourcing the issues here: Advanced Roadmaps integration. In particular, have a look at the "Source a subset of epics with their full hierarchy" example.

Link to the app in case you decide it's for you: JQL Search Extensions

Kian Stack Mumo Systems · Answer

Try using the following query

SUBQUERY OR portfolioChildIssuesOf("SUBQUERY"). This should return all the epics you want, and all the child issues you want.