Re: [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.


before asking=)

Sorry if my question sounded like I haven't searched the wiki and the lists

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:[EMAIL PROTECTED]
Sent: Monday, April 30, 2007 6:42 PM
To: Konstantin Naryzhniy
Cc: rt-users@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: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

PGP.sig
Description: This is a digitally signed message part

_______________________________________________
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