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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Assign dynamic list of epic keys to your own local smart values then call the smart values in jql.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sounds like you're about to spend some $!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.