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.
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!
so you want to know the name of the epics that are currently being worked on in the active sprint? try this...
you can also use Sprint in openSprints() to simplify/broaden your search
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.
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 :)