I have a SCRUM Board meant to view the current Sprints across an entire department. The goals are the following.
First, I just grabbed the Issues.
project in (many many projects) AND issuetype in standardIssueTypes() AND Sprint in openSprints() ORDER BY Rank
Because Epics aren't embedded in Sprints, this left the Epics out. So I explictly grabbed the Epics.
project in (many many projects) AND (issuetype in standardIssueTypes() OR issuetype = Epic) AND Sprint in openSprints() ORDER BY Rank
This pulled in every single Epic ever made. I then tried to limit the Epic selection, though I knew this was too blunt a tool to deal with the teams' abandoned, unclosed, orphaned, and neglected epics.
project in (many many projects) AND issuetype in standardIssueTypes() AND (Sprint in openSprints() OR (issuetype = Epic AND updated > -6w)) ORDER BY Rank
How do I get only the Epics that are linked to from Issues in the current Sprint?
> How do I get only the Epics that are linked to from Issues in the current Sprint?
Sorry about this quick answer without reading through your entire question. But have you tried
sprint = "xxxx" and "Epic Link" = Something
Sorry, Bhushan, but this won't fix my issue.
Your solution would only work for pulling Stories (or other Issues linked to Epics). This is not what I want. I want to pull Epics that have (1) have links to them from (2) Issues in the current Sprint. (I can get the "current sprint", but saying…
Sprint = openSprints()
. The challenge remains the Epics.
I've tried to find a solution for this myself as well. And I did, at least for my application and intended use.
You need to have ScriptRunner!
And in ScriptRunner I used the epicsOf() function like so:
project = MyProject AND issueFunction in epicsOf('"Backlog" = "MyBacklog" AND Status in ("Ready for Backlog", "In Progress", "Ready For Verification", "Under Verification", "Resolved")')
This enabled me to filter out Epics for my backlog that were relevant to ongoing tasks, thus using the "Epics" window in the backlog properly without any irrelevant Epics.
I created this for my project and it returned all the EPICS that are linked to issues in the current sprint:
project = XXX AND issueFunction in epicsOf("sprint in opensprints()")
Since you have multiple projects you can modify the above to:
project in(XXX, XXX, XXX) AND issueFunction in epicsOf("sprint in opensprints()")
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event