How to remove a single sprint from tasks in bulk?

Question

I keep having an issue where resolved issues roll forward to the next sprint which is now causing hundreds of tasks that are already resolved to show in the current sprint.  I have looked for resolutions to this issue but only found solutions that will remove ALL the sprint values from these tasks.  I want to retain those historical sprint values (we did work on the tasks in those sprints).  However, how do I remove the current sprint from these tasks without removing all the other sprint values in the field?  Thank you!

Daniel Ebers · Answer

The right-most column in a board will classify issues as "done". Cancelled on the other hand counts as a valid resolution per definition.
If the resolution is missing you could fix it through a bulk edit. In case you would do it via Script Runner there would be needed no code - this is a built-in script (however, this can be neglected as you say you don't have the App).
The information about the sprints the issue was in should be kept in order being able to do historical reports.

Theresa Rogers · Answer

I don't believe I have script runner - if I did I doubt I'd be able to write a script easily to do this myself.  I think my issue is two-fold.  1) Some statuses might not be marked as resolved and that is why they continue to roll forward to the next sprint and the next.  2) Now that I have a ton of resolved tasks in my sprint, I want to get them out of this sprint in bulk.  However when I try a bulk change and change the sprint field to ' ' it removes all sprint values that were ever in that field, not just the current sprint.    If there was simply a way to remove the current sprint only from a batch of tasks, that would solve the immediate issue.

Daniel Ebers · Answer

"Archive" as a resolution is a valid value by means how Jira works.
This should not be the cause from my opinion.

If you have, for example, Script Runner (App) there is the possibility to do a bulk fix of resolutions while, to be honest, I do not believe it is necessary in this scenario.

If your question was on where to change behaviour so the resolution is something else than "Cancelled" you would have to edit the workflow for the transition which puts the resolution to the issues (most likely one of the last transitioning to something like "resolved" / "closed").