Is it possible to un-merge tickets?

RT Users
1

After looking through the docs (and searching for the string ‘merge’
– I got one hit, which did not address this issue), I suspect not.
Does anyone know of a way? Thanks…

Tom Barron tbarron@ornl.gov
Computer Science & Mathematics (865) 576-1620 (voice)
Oak Ridge National Laboratory (865) 241-2850 (fax)

2

After looking through the docs (and searching for the string ‘merge’
– I got one hit, which did not address this issue), I suspect not.
Does anyone know of a way? Thanks…

Hand-tweaking the EffectiveId field in the Tickets table?

/Autrijus/

3

After looking through the docs (and searching for the string ‘merge’
– I got one hit, which did not address this issue), I suspect not.
Does anyone know of a way? Thanks…

Hand-tweaking the EffectiveId field in the Tickets table?

Thank you! This appears to do exactly what I want. Here’s the perl
subroutine we’re using, in case the code is helpful to anyone else:

sub rt_unmerge
{
my ($arg, $symbol, $help, $fname);
($arg) = @_;
($arg eq “help”) && return(“unmerge a ticket”);

$exec = 1;

GetOptions(“-exec!” => $exec,
“-ticket=s” => $ticket_id);

fatal(“usage: rttool unmerge -ticket ”)
if (!defined($ticket_id));

$mysql = which mysql;
fatal(“mysql is not available on this machine”)
if ($mysql =~ /no mysql in/);

$cmd = “mysql -u $username $dbname -p -e "update Tickets”
. " set EffectiveId = id where id = $ticket_id"";

if ($exec)
{
print(“$cmd\n”);
system($cmd);
}
else
{
print(“would do ‘$cmd’\n”);
}
}

Tom Barron tbarron@ornl.gov
Computer Science & Mathematics (865) 576-1620 (voice)
Oak Ridge National Laboratory (865) 241-2850 (fax)