Mass move entries to another project

Discussion forum about Anuko Time Tracker
Post Reply
pawel
Posts: 2
Joined: Wed Apr 29, 2015 9:52 am

Mass move entries to another project

Post by pawel » Mon Aug 03, 2015 1:11 pm

Hi,
I'd like to move multiple time entries from multiple projects to single new project. Will this simple SQL query do the job?

Code: Select all

UPDATE tt_log SET project_id=100 WHERE project_id=1 OR project_id=2 OR project_id=...;
Do I need to change anything else (I do not have any tasks or invoices)?

peter
Posts: 77
Joined: Sat May 29, 2010 2:06 pm

Re: Mass move entries to another project

Post by peter » Wed Aug 05, 2015 4:30 pm

Looks like your query will do the job.

Post Reply