Yeah, it can be that easy as described by Lars, however you loose notifications when you move txns around using this way.
May be it's better to forward again to correct ticket and tender an apology in another. On Fri, Oct 31, 2008 at 5:23 PM, Lars Kellogg-Stedman <[EMAIL PROTECTED]> wrote: >> I know how to identify the transaction numbers (from the links to the >> transactions in the ticket history), but is there any easy way to move the >> transactions to the correct ticket? > > I'm sure someone else will have a more authoritative answer, but it > looks as if you could simply update the "objectid" field of the > corresponding transaction in the transactions table. Something like: > > update transactions set objectid = <new ticket id> where id = > <transaction id>; > > This worked just fine in my simple test. Note that I'm working from > RT 3.8.1 assumptions, but our production RT 3.4.6 install appears to > have a similar schema. > > -- > Lars Kellogg-Stedman <[EMAIL PROTECTED]> > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
