How to find number of stories or task added & removed from the given sprint

[jai shree ram]

How to find number of stories or task added & removed from the given sprint

[Ganesh Babu · Accepted solution]

Hi @jai shree ram 

For this you might need a scriptrunner plugin which will help you to find your needs. The query will be something like this

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

this will be very handy. Look at the following link

https://jamieechlin.atlassian.net/wiki/spaces/GRV/pages/33030163/Scripted+JQL+Functions

or 

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.

[jai shree ram]

Thanks for your answer,

I completely got how to get the story or task that is close or completed in given sprint using jql like (Sprint = 45297 and (issuetype =Story or issuetype = Task ))

but I want Issues Removed from Sprint how to find it ?

[Ganesh Babu]

Hi @jai shree ram 

The above mentioned query and answer will help you to find the issues removed after the start of the sprint. in the same way you can find that are added after the start of the sprint. But the thing is the JQL Query can be achieved using scriptrunner only. This is what i answered earlier above

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

[jai shree ram]

Thanks for your answer.