JQL for Epics assigned to me & all stories in said Epics

[JA]

Hello,

I used to have a filter in Jira that would pull only Epics that were assigned to me and all stories under those Epics. I then built out my Jira Plan based on this filter. Now that we've moved to cloud my filter is no longer working (this was built out using ScriptRunner Enhanced Search). We will also likely be removing this plugin so needing to find a native way to pull these issues in Jira cloud. 

Does anyone have experience with this? Is there a JQL that can be built natively in cloud to pull this exact set of issues? Or is my only option to build my plan based on all projects and remove issues I don't want to see? I could go this route, but it's definitely not my first choice. 

TIA,

J

[Trudy Claspill · Accepted solution]

Hello @JA 

There is not a native JQL method to get what you want.

First you want to filter for the Epics assigned to you:

issueType=Epic and Assignee=<you>

There are a couple of ways to get the children of Epics, but none of them take another filter as input.

parentEpic() - https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#parentEpic--

portfolioChildIssuesOf() - https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/#Child-issues

The alternative is that once you have that list you build out the query manually adding each Epic's key:

issueType=Epic and Assignee=<you> or (issue in parentEpic(key1) or issue in parentEpic(key2) or issue in parentEpic(key3) or ...)

And you would have to periodically update that query when the Epics assigned to you change.

[Charlotte Santos -Appfire-]

Hi @JA 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all the Epics assigned to you and their stories: 

issue in epicsOfChildrenInQuery("") AND assignee = JA OR issue in childrenOfEpicsInQuery("assignee = JA") AND type = Story

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[JA]

Thank you. Unfortunately we don't have the JQL Search Extensions app so that won't work but I appreciate the response. :)