nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Mikael Sandberg

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.

All comments

Mikael Sandberg

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.

Luyang Zhang

Thanks you for your answer!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud