I want to do bulk update for the tickets which are more than 6 months old

Question

There are jira tickets in the backlog column in jira which are old more than 6 months. I’m trying to move that all those old tickets to another sprint which I created for the old tickets.

what will be the query for that and where I can write that query ? Please advise.

Trudy P Claspill · Answer

So, your criteria are: 1. The issue is in the "backlog" column 2. The issue is displayed in the Board view of a Scrum board, which means it is in an Active Sprint 3. The issue has not been updated for 6 months or longer. In that case the filter you would need is: status in () and sprint in openSprints() and updated < startofmonth(-6) and issuetype not in subTaskIssueTypes() I added the last criteria checking the issue type because you can't directly change the Sprint for subtasks; they inherit the sprint information from their parent issue. Replace with a comma separated list of the statuses that you have mapped to the Backlog column in your board.

Meghana kamble · Answer

I’m referring to an actual column/status in my scrum board which is “backlog”

Trudy P Claspill · Answer

Hello Meghana,

Thank you for that additional information.

Are you working with issues in a Team Managed project or a Company Managed project? You can get that information from the Type column on the View All Projects page under the Projects menu.

Can you provide a screen image of what you are viewing when you are referring to the "backlog Column"? It is unclear to me if you are referring to the Backlog screen and the Backlog list on that screen, or if you are referring to an actual column/status in your scrum board.