JQL to find all epics in certain initiatives in advanced roadmaps

[Scott Lingle]

We have a large roadmap that acts as our strategic plan.  In that roadmap are many initiatives.  Under them, epics, etc.  Our team's projects are by Epic that rollup into initiatives, etc.  which means multiple teams can have epics under an initiative.

I'm grabbing all of the epics that belong to my team.  Easy enough - I have a label on all of our assigned epics.  What I really want to get is all the initiatives in which they are contained and ultimately their strategic priority.  Basically, my team's subset of the roadmap with the hierarchy in-tact.

We're in cloud, with ScriptRunner.  Epics are not linked to their initiative so I have to use the Portfolio hierarchy. 

I could have done this on data center pretty easily, but the answer eludes me in cloud.  Any help would be greatly appreciated.

[Daniel Turczanski - JQL Search Extensions]

Hi Scott,

With standard JQL you can only get parents of specific epics.

You may want to consider our professional indexing service JQL Search Extensions.

After you install the app, you are able to find parent initiatives of epics witha particular label:

issue in parentsOfIssuesInQuery("labels=mylabel and type=Epic")