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

[Meghana kamble]

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 Claspill]

Hello @Meghana kamble 

You can learn more about creating filters here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

How are you evaluating that the issues are more than 6 months old? Is that based on the date they were created?

Are you working with 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.

The exact filter you need depends on the filter used by your scrum board.

If you are working with a Team Managed project, then the filter for its Scrum board encompasses the entire project.

If you are working with a Company Managed project, or a scrum board that encompasses more than one project, then your board filter may be different.

You would need to add the following criteria to the board filter to get the issues you want, using the issue creation date as the basis for determining issues are 6 months or more old.

statusCategory != Done and (sprint is empty or (sprint not in futureSprints() and sprint not in openSprints()) ) and created < startofmonth(-6)

[Meghana kamble]

Question: How are you evaluating that the issues are more than 6 months old? Is that based on the date they were created?

A:- it is based on last updated date. If last updated date on the tickets in backlog Column in current sprint is more than 6 months then I need to move those all backlog tickets in the another sprint called Archive sprint which I created to track old backlog tickets.

[Trudy Claspill]

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.

[Meghana kamble]

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

[Trudy Claspill]

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 (<backlog>) 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 <backlog> with a comma separated list of the statuses that you have mapped to the Backlog column in your board.