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

JA April 25, 2024

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

2 answers

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 25, 2024

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.

0 votes
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 26, 2024

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 April 26, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events