Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL to return all issues in a list of epics

Luyang Zhang October 20, 2022

I'm looking to use raw JQL (not using any plugins) to filter for all issues (tasks, bugs, subtasks) under several epics from another JQL.

I got a list of desired Epic through this JQL: project IN ("A Pjt","B Pjt") AND " Quarterly" = "2022 Q4" AND type = "Epic"

In order to get all issues under these epics, I tried to use parentEpic() function with: parentEpic IN ('project IN ("A Pjt","B Pjt") AND " Quarterly" = "2022 Q4" AND type = "Epic').

However it returns the issue key of "project IN ("A Pjt","B Pjt") AND " Quarterly" = "2022 Q4" AND type = "Epic"" is invalid.

Any help or suggestions would be appreciated. 

2 answers

1 accepted

2 votes
Answer accepted
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 20, 2022

It is not possible to do without an app. Default JQL cannot use nested queries like that to get Epics and their associated stories/tasks/subtasks. If you do not want to use an app that extends JQL your only option is to include each Epic as part of your query.

Luyang Zhang October 21, 2022

Thanks you for your answer!

0 votes
Cloudites Owner
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.
October 20, 2022
Luyang Zhang October 20, 2022

Thank you for your answer! In my case, I am not using one or several specific epics, but a dynamic list of epics based on filters. Since this approach only works when knowing the epic keys, it doesn't solve my issue.

Cloudites Owner
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.
October 20, 2022

Assign dynamic list of epic keys to your own local smart values then call the smart values in jql.

Luyang Zhang October 20, 2022

Actually I am using the Smartsheet/ Jira connector that only accept one raw JQL string. Since the connector sends this JQL to Jira sever directly, Jira automation and local smart values won't be read by it in this case.

Cloudites Owner
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.
October 20, 2022

Sounds like you're about to spend some $!

Like • Eduardo Godinez likes this

Suggest an answer

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

Upcoming Jira Events