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

Erik Berg February 17, 2013

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?

3 answers

1 accepted

0 votes
Answer accepted
codelab expert
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2013

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

0 votes
Brian Spence
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2016

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 February 24, 2020

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

0 votes
Cecile Chateau January 30, 2015

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 October 25, 2019

@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')

Suggest an answer

Log in or Sign up to answer