ScriptRunner - JQL to grab Epics in a different project linked to stories of my project

[Roberto L]

Hello Community,

I want to know if there is a way to grab all Epics, no matter what project they may be in, that are linked to stories under a specific project.

For example,

I have project HTP with Stories HTP-1 HTP-2 HTP-3 and Epic HTP-20.

I have project ALM with stories ALM-2 and Epic ALM-22.

HTP-1 and HTP-2 and linked to Epic HTP-20.

ALM-2 and HTP-3 are linked to Epic ALM-22.

I would like to know if there is a JQL that would fetch me HTP-20 (since my story is linked to it) and ALM-22 (since one of my stories is linked it) regardless of what project they may be in. I want to get all Epic's that are associated with the stories under a specific project.

Any information is greatly appreciated!

-Roberto

[Peter DeWitt · Accepted solution]

Roberto try this: 

issuefunction in epicsOf('issuetype = story and assignee  = yourname')

This will get you all epics of any stories you are assigned too.

issuefunction in epicsOf('issuetype = story and project = key')

This one will pull all stories in a project and return their Epics.

gl - peter

[Roberto L]

@Peter DeWitt,

Thank you Peter, this is very helpful.

Will issuefunction in epicsOf('issuetype = story and project = key') also pull Epics that are outside of my project but are linked to it via Stories in my project?

I don't want the stories that are assigned to me specifically, I just want all Epics that are linked to Stories in my project.

-Roberto

[Peter DeWitt]

Yes - as long as one of the issues in the internal part of the query has an epic link to it.