JQL to show EPICS for the given keys and its stories and subtasks in Jira cloud

[Vinoth Vanchinathan]

I have some epics (xx-1, xx-2, xx-3, xx-4) and I want to list down the EPICS, its stories and its sub-tasks. No add-on installed in my Jira cloud. So I need a plain JQL.

[Bill Sheboy · Accepted solution]

Hi @Vinoth Vanchinathan 

Short answer: Without add-ons or Atlassian adding a new feature, I do not believe you can do this with one query.

Longer answer: You can get close with some queries, exports to Excel, and follow-up queries.  For example...

This query would return the epics, stories, and bugs associated to a list of epics:

project = myProject
 AND "Epic Link" IN (epicKey1, epicKey2, etc.)
 OR parentEpic IN (epicKey1, epicKey2, etc.)

Once you have the story and bug list, you could use a second query to get the sub-tasks with the following

project = myProject
 AND parent IN (storyKey1, storyKey2, bugKey1, etc.)
 AND issuetype IN subTaskIssueTypes()

Best regards,

Bill