Sql querries in scrips

Hello List,

is it possible to querry the rt3 db in scrips? and when yes how?

what i want is to automaticly move a new created ticket to a user
based on how bussy he is. so i have to query the db or get infos how
much tickets a user own and what status this ticket have.

Gruesse Daniel

Wenn wir bedenken, daß wir alle verrueckt sind, ist das Leben erklaert.
[Mark Twain]

Hello List,

is it possible to querry the rt3 db in scrips? and when yes how?
Yes, this possible.

what i want is to automaticly move a new created ticket to a user
based on how bussy he is. so i have to query the db or get infos how
much tickets a user own and what status this ticket have.
Oh, nice idea, owners auto balancer for tickets.

You can use something like this(untested):
my $tix = RT::Tickets->new($self->CurrentUser);
$tix->FromSQL(“Owner = <user_id> AND Status = ‘new’”);
$tix->Count;

wiki is your friend


Gruesse Daniel


Wenn wir bedenken, daß wir alle verrueckt sind, ist das Leben erklaert.
[Mark Twain]


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.