Un-merging tickets

RT Users
1

Hi All,

a quick question: Is it enough to do

update tickets set effectiveid = id where id = 11215;

to unmerge ticket no. 11215 from 11190, into which it accidentally
got merged? Or are there other places where I should look at?

(RT 2.0.15/RHDB 2.1)

Binand

2

I think that is enough but i am not sure since there is also an
effectiveticket field in the transactions table but it doesn’t look like
that ever gets set. I would say that if you changed the effectiveid of
11215 from 11190 to 11215 it would unmerge the two tickets.

John
At 10:10 PM 5/4/2003, you wrote:

Hi All,

a quick question: Is it enough to do

update tickets set effectiveid = id where id = 11215;

to unmerge ticket no. 11215 from 11190, into which it accidentally
got merged? Or are there other places where I should look at?

(RT 2.0.15/RHDB 2.1)

Binand

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”

3

If one accidentally merges one ticket with another, is there a way to
undo it?

4

in rt 2 go to the tickets table in your database and find the ticket that
was merged in. the effective id will be different from the id field (the
effecive id will be the id of the ticket that it was merged into.) to un
merge it change the effective id back to be the same as the id and it will
be unmerged.

example

  ticket 12 merged into ticket 14.

  id     effectiveid
  12      14                 <----- Change this record so that 14 is 12

and it will be unmerged.
13 13
14 14

John
At 06:30 AM 6/13/2003, Ian Grant wrote:

If one accidentally merges one ticket with another, is there a way to
undo it?

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”

5

in rt 2 go to the tickets table in your database and find the ticket that
was merged in. the effective id will be different from the id field (the
effecive id will be the id of the ticket that it was merged into.) to un
merge it change the effective id back to be the same as the id and it will
be unmerged.

Thanks. This seems to have worked with RT3 too.

Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
Phone: +44 1223 334420