Page 1 of 1

change reporter for large amount of reports

Posted: 05 Jun 2007, 07:41
by smlp
Hi everyone,

a colleague of mine left our company and we need to re-assign his bugs to someone else by changing the "reporter" to someone else. It's about 600 reports. Changing every singe report step by step takes way to much time, someone got an idea how this can be done quickly? Would you recommend usind SQL directly on the database or is there a possibility to to this via the GUI? We use Mantis 1.0.7. Please help.. :(

Thanks in advance,

Sebastian

Re: change reporter for large amount of reports

Posted: 05 Jun 2007, 08:05
by deboutv
smlp wrote:Hi everyone,

a colleague of mine left our company and we need to re-assign his bugs to someone else by changing the "reporter" to someone else. It's about 600 reports. Changing every singe report step by step takes way to much time, someone got an idea how this can be done quickly? Would you recommend usind SQL directly on the database or is there a possibility to to this via the GUI? We use Mantis 1.0.7. Please help.. :(

Thanks in advance,

Sebastian
Hi,

You can do it by SQL but no email will be sent...

Code: Select all

UPDATE mantis_bug_table SET handler_id=2 WHERE handler_id=1
1 is the user left
2 is the new assignee.