JQL: "added to current sprint" and "removed from current sprint"

[Erik Berg]

To keep track of what tasks are added or removed from an active sprint I would like to create some filters that can display issues "added to current sprint" and also "removed from current sprint". Is this possible to do with JQL?

[codelab expert · Accepted solution]

No, this is currently not possible. Here you have to write your own plugin.

[Brian Spence]

Somewhat of a workaround is to write your JQL as:  project = "WhateverProjectYouWant" AND resolution = Unresolved AND Sprint in closedSprints()

The assumption is that you would only be removing unresolved issues from a Sprint.

To narrow it down to a specific sprint, you could just replace the "Sprint in closedSprints()" clause with a Sprint = YourSprint.

Since the Sprint Report has a section titled "Issues Removed from Sprint" it must be possible to write such a query, but it is either not possible through JQL, or Atlassian has chosen not to make it known.

[Filip Pokorny]

This won't work if you remove the sprint entry completely or if you move the issue to a future sprint (not yet closed).

[Cecile Chateau]

with the version 3.0 of scriptrunner, you now have a JQL query called addedAfterSprintStart(), with 2 parameters, the board name (mandatory), and the sprint name (optional).

your JQL query is issueFunction in addedAfterSprintStart("BOARDNAME", "SPRINTNAME")

you can have a look here https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions

unfortunately, i haven't found yet the same for "removedaftersprintstart().

[Carol Jones]

@Cecile Chateau - looks like ScriptRunner comes through again!  Not sure when it was added, but they do have the below now! 

issueFunction in removedAfterSprintStart('board name', 'sprint name')