[rt-users] SetOwner chemistry

[Jesse Vincent]

On Apr 30, 2007, at 10:49 AM, Konstantin Naryzhniy wrote:

> Jesse!
>
> Thank you very much, sir! It's all clear now.
>
> Sorry if my question sounded like I haven't searched the wiki and  
> the lists
> before asking=)
>

It's good to get it into the archives every now and then ;)
Also, Parallels makes my development life better.

Best,
Jesse

>
> Stan
>
> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com]
> Sent: Monday, April 30, 2007 6:42 PM
> To: Konstantin Naryzhniy
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] SetOwner chemistry
>
>
> On Apr 30, 2007, at 10:23 AM, Konstantin Naryzhniy wrote:
>
>> Hello!
>>
>> RT 3.6.1
>>
>> Could anyone predict the results of setting ticket's owner manually
>> through
>> simple SQL query:
>>
>> update Tickets set Owner = 123456 where id = 654321;  ?
>>
>> I know that there are several tables updated in SetOwner method and
>> I am
>> interested what consequences such  "brutal" workaround may cause.
>> So far I've tested this query and it looks fine for ticket updating
>> and
>> resolving.
>>
>> If using this query multiple time eventually can trigger RT failure I
>> wouldn't want to use it.
>
> Using it even once will hurt you, alas.
>
>> Also, I would appreciate it very much if you could provide me with
>> the list
>> of tables updated during SetOwner.
>>
>> The reason I don't favor using SetOwner is that I do not know how
>> to=) I'm
>> trying to write a custom auto ticket assingment perl-module that
>> should be
>> put in crontab and I've just no idea how to utilize RT lib in there.
>
>
> There should be some samples on the wiki to help you out, but this
> (untested) code may do what you mean:
>
>
> #!/usr/bin/perl
> use warnings;
> use strict;
> use lib '/opt/rt3/lib';
> use RT;
> RT::LoadConfig;
> RT::Init;
> use RT::Ticket;
> use RT::User;
>
> my $user = RT::User->new($RT::SystemUser);
> $user->LoadByCols(Name => 'root');
> my $ticket = RT::Ticket->new($RT::SystemUser);
> $ticket->Load(1234);
> my ($val,$msg) = $ticket->SetOwner($user->id);
>
> print $msg;
>
>
>
>
>
>> Seriosly, I'm no programmer))
>>
>> Any help and advice appreciated,
>>
>> Sincerely,
>> Stan
>>
>> _______________________________________________
>> 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
>>
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070430/d9706b23/attachment.sig>