How do I move a large number of worklogs in bulk to a new ticket?

[StephanieC]

We have been experiencing lagging and locking issues that we were advised is linked to our practice of having "bucket" tickets that are used year-over-year for overhead work logs. 

We do need to report on some of this time historically and have since enacted policies to create new tickets each year for these activities - but how do we keep the existing tickets/worklogs from continuing to cause issues? We do not have the capacity to move these worklogs one at a time to new tickets. 

We would like to be able to bulk move the worklogs by year to new tickets for those years where we cannot delete the worklogs. 

Is it possible to archive a portion of the worklogs? or will we have to archive the whole tickets? Is it possible to make archived worklogs available for reporting but not need to be indexed constantly? 

[Matt Doar · Accepted solution]

If you are on Data Center and have something like ScriptRunner, this is possible with a script, lots of testing in non-prod and some exploratory coding. A quick google of "jira bulk move worklogs" suggests that the Tempo plugin will also do this in Cloud. 

[Craig Nodwell · Accepted solution]

Agree with @Matt Doar this is something that scriptrunner would be able to handle for you.