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]
The rt-users Archives
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.