Hi, I'm guessing this is as simple as selecting the notes from the article database and updating the ticket_id field to set it to the correct ticket number. To get to a ticket_id from a ticket number do a : SELECT * FROM ticket where tn='<ticket number>'; The 'id' field should match the ticket_id field in the article database. Regards, Arnold.
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of LQ Marshall Sent: donderdag 20 maart 2008 20:22 To: 'User questions and discussions about OTRS.org' Subject: [otrs] Move a Note
My apologies for not previously researching this, but the answer I'm looking for is a simple one. (Mostly Yes or no.)
We had a user accidentally record several notes in the wrong part of a two linked tickets.
Does anyone know if it would be a simple process to go into the DB and modify the records to move the notes to the correct ticket? This isn't big enough issue to challenge corrupting the db over. I would think this to be very simple.
If you also happen to know what would need modifying would appreciate the additional info.
I you have an opinion or knowledge let me know.
tia,
LQM
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/