[rt-users] undoing a ticket merge or splitting a ticket

[Dmitriy Yermakov]

Brett Sheffield wrote:
> I accidentally merged one ticket with the wrong numbered other ticket
> (easy to do as I'm just keying a number into a freetext field on the
> links page - I imagine in a busy helpdesk this could happen quite
> often).  Is there a simple way to undo this?
> 
> After googling this, searching through the wiki and the rt-users
> archives I see lots of requests for a feature to 'split' tickets.  eg. a
> ticket containing more than one request needing to be split in two.
> Whilst that would be nice, I think what I'm looking for is much simpler
> - the ability to undo a merge.

For example
[rt3]> select id,EffectiveId from Tickets where id =6999;
+------+-------------+
| id   | EffectiveId |
+------+-------------+
| 6999 |        6842 |

so, ticket #6999 merged into ticket #6842
for un-merge
[rt3]> update Tickets set EffectiveId=6999 where id=6999;

-- 
Dmitriy Yermakov