JQL Query to show all Epics and Stories in a Release

Drew Bryce July 24, 2017

I'm trying to write a JQL to show all of the Epics currently assigned to a Release/Version, and all of the Stories that are linked to those Epics

1 answer

2 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 27, 2017

With JIRA alone, I don't think this is possible to do in a single JQL query.   You could use two different queries to do this, but the first would have to be

issuetype=epic and fixVersion=7.3.4

to find the epic issue keys.  Let's say you had two diffent epics returned of ABC-22 and ABC-34.   You would then need to take the issue keys returned by that query and enter them into another query such as

"Epic Link" in (ABC-22,ABC-34)


If you're looking to return both results in a single query dynamically, then you would need to use a 3rd party plugin like Scriptrunner to be able to do this.  Scriptrunner adds a number of JQL functions such as issuesInEpics

With that plugin to JIRA you could do


issueFunction in issuesInEpics(issuetype=epic and fixVersion=7.3.4) OR (issuetype=epic and fixVersion=7.3.4)

This single query can return both the epics and all the issues in those epics, but only if you have scriptrunner add-on enabled in your JIRA instance.

Suggest an answer

Log in or Sign up to answer