JQL to return all issues in a list of epics

[Luyang Zhang]

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. 

[Mikael Sandberg · Accepted solution]

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]

Thanks you for your answer!

[Cloudites Owner]

https://community.atlassian.com/t5/Jira-Software-questions/parentEpic-search-function-always-tells-me-issue-key-invalid/qaq-p/1610112

[Luyang Zhang]

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]

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

[Luyang Zhang]

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]

Sounds like you're about to spend some $!