Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,103
Community Members
 
Community Events
168
Community Groups

JQL to show all Epics of the userstories in an open sprint

Hi,

I would like to write a JQL query to pull all Epics which are related to the committed user stories in an open sprint.

4 answers

0 votes

Hello everyone,

I had the same problem and find the solution using Dashboards. Because it`s difficult to install any addons in my organisation and we haven`t installed Script Runner.

The solution is to use simplest JQL script for issues in the sprint: Sprint in openSprints()

And to set up any dashboard chart using those query and showing Epic Link field.

So I can see all the epics of current sprint along with count of issues of each epic.

Hope, this could be helpful for somebody else.

Hi @Karthik Balasubramanian and @Hari Viswanathan,

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in epicsOfChildrenInQuery("sprint='My sprint'")

Check out the documentation for more examples.

I hope this helps!
Daniel

@Karthik Balasubramanian : Did you manage to get an answer for this?

0 votes

so you want to know the name of the epics that are currently being worked on in the active sprint? try this...

  1. jql --> Sprint = "name of your sprint" and "Epic Link" is not empty
  2. add the Epic Link column

you can also use Sprint in openSprints() to simplify/broaden your search

Hi Jack,

The above JQL 1 brings out all the issues(Story, improvements, spikes, tasks) which are  linked with some Epic. But I want to bring out the EPICs which are linked to the issues committed in a particular sprint.

Something like SQL below:

Select Epics from issues where sprint = current sprint

Note:  JIRA is hosted internally.

@Karthik Balasubramanian 

If you have Script Runner installed on your server, you can use this JQL to find the Epics with issues in open sprints:

issueFunction in linkedIssuesOf("Sprint in openSprints()", "has Epic")

 Because we have many projects, I prefix the query with "Project = <key> AND".

 Hope this helps :)

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events