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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/ _______________________________________________ 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/
