Find the issues in current sprint that have previously been assigned to a closed sprint.

[Admir Olovcic]

Hi,

I am looking to get a list of issues in the current active sprint that have previously been assigned to a sprint. Essentially i need to know how many issues in the current sprint have carried over from previous sprints and which was the last sprint they were assigned to. 

[Deleted user]

Hi @Admir Olovcic,

My suggestion would be to use the JQL query below;

project = PROJECT and Sprint in openSprints() and sprint = SPRINTID

This should allow you to find issues that are currently in the latest sprint of a project and were also on a particular previous sprint.

For find all issues that were carried over from previous sprints please use the following;

project = PROJECT and Sprint in openSprints() and sprint in closedSprint()

Hope this helps

[Tarun Sapra]

Just to add to Danny's answer if you are specifically looking only for issues in *active* sprint then you can add the following criteria in above JQL

project = PROJECT and (Sprint in openSprints() and Sprint in closedSprints() and Sprint not in futureSprints())