Once upon a time I needed to change the merging of an article into the wrong ticket. After an analysis of the database discovered that …
update article set ticket_id=<ticket_id> where id=<article_id>;
I don’t know if this is still valid… I was working with an old DB version at the time. May allow you to program your modifications.
Of course start with a back-up of the DB, and optimally test on a non-production instance.
gl
From: otrs [mailto:otrs-bounces@lists.otrs.org] On Behalf Of Gerald Young
Sent: Thursday, November 29, 2018 8:47 AM
To: User questions and discussions about OTRS. <otrs@lists.otrs.org>
Subject: Re: [otrs] Merge tickets that start with same string
Ok, fair. I have a thought about select id, TN, title from ticket [optional:where title like 'needle%']
and then use otrs.Console.pl to ticket merge. In excel, this could concatenate ticket numbers or id's in individual commands to copy paste to shell command line. Pick a single destination to merge to per criteria.
I am not at a desk, but am writing to point toward an option. Test one to make sure the command line works as expected.
On Thu, Nov 29, 2018, 8:20 AM William Edwards | Cyberfusion <wedwards@cyberfusion.nl wrote: