[rt-users] Moving transactions between tickets

Ruslan Zakirov ruz at bestpractical.com
Fri Oct 31 10:57:03 EDT 2008


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 <lars at oddbit.com> 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 <lars at oddbit.com>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.



More information about the rt-users mailing list