How can I remove a sprint number on several jira tickets in bulk?

[Bridgette Dennis]

I have 96 issues that are closed that seem to capture my new sprint number that I have created. I dont want to delete the sprint that the issues were compelted in , but I want to delete the new sprint number that the issues are trying to tie to .

[Nic Brough -Adaptavist-]

I strongly recommend that you do not do this.  Deleting the sprint information on an issue destroys all the reporting on the sprints.

To stop having issues move to the next sprint, you need to flag them as "done" before you close the current sprint.

[Jack Brickey]

Hi @Bridgette Dennis , you can consider using Automation for this. However, zeroing in on removing the culprit sprint needs a bit of thought. Is the sprint to be removed associated with ANY issues where it should remain? If so then we need to ensure to identify/exclude those issues in the issues JQL branch.

Roughly....

Trigger - manual

Branch related issues JQL

Action - edit issue - {{sprint.remove("Sprint xxx")}}

[Bridgette Dennis]

Hi Jack im only trying to remove from tickets that I have closed . 

[Jack Brickey]

Can you construct a JQL that returns only the issues where you want to remove the sprint? If so, please share. If you need assistance with setting up the proposed automation rule, I can help in about an hour as I am away from my desk ATM. 

[Bridgette Dennis]

Here is an example, as you can see I have done a query where I only see the tickets that are closed with the sprint 10.01.2023 that I do not want 

[Jack Brickey]

Ok so you can use that JQL in the rule to iterate thru and the action should remove the specified sprint. I recommend performing a test on a single issue first. To do this, we would simplify or restrict the JQL by including.….and key = SUP-5603

Once that works correctly, then we can remove that additional restriction. does that make sense?

[Bridgette Dennis]

yes when i do that I still dont see an option to remove the 10.01.23 sprint . There is an option to change sprint , but JIra doesnt give me an option to remove ?

[Jack Brickey]

@Bridgette Dennis , so are you using the smart value? Is the name of the sprint literally "10.01.23 sprint"? if so the smart value would be...

{{sprint.remove("10.01.23 sprint")}}

[Valerie Knapp]

Hi @Bridgette Dennis , thanks for your question. I have understood you want to update the sprint number to a group of issues. You should be able to do this with a bulk update.

In the same moment, you could also re-open them if you like.

What do you think? Will this work for your requirement? If not, please give us your feedback and either I or someone else will try to help.

Cheers

[Bridgette Dennis]

Hi Valerie, I have selected all the items in Jira that are closed but no I dont want to open them. Some of the tickets were completed in jira sprint 1, and or 2. but now that the ticket is closed and I've started a new sprint , its saying these closed tickets are also in sprint 3. Does that make senses. I want to remove sprint 3 but want to ensure they stay in the sprints they were actually completed in.

I do not see a way to remove one sprint number from a bulk of tickets

[Valerie Knapp]

Hi @Bridgette Dennis , I just had a look in the Atlassian documentation and they have provided this guide  - Delete a completed sprint in a company-managed project | Jira Software Cloud | Atlassian Support

Is this what you want to achieve? Have you tried this already?

Please let us have your feedback.

Cheers

[Bridgette Dennis]

Hi Valerie ,

I dont want to delete the sprint - I want to delete the items that are "Closed" in the active sprint . 

they shouldnt be apart of this new sprint and Im sure I will end up seeing the tickets soon that were in the sprint that need to be closed so I need to find a  solution soon.

Thanks