FromSQL not Limit
$tix->FromSQL('Queue = "CustomerCare" and Status = "resolved" and
Status = "open"');
But note that 'Status = "resolved" and Status = "open"' is wrong
condition, most probably you want '( Status = "resolved" OR Status =
"open" )'
On 3/15/07, Mathew Snyder <[EMAIL PROTECTED]> wrote:
Running this:
#!/usr/bin/perl
use warnings;
use strict;
use lib '/usr/local/rt-3.6.3/lib';
use lib '/usr/local/rt-3.6.3/local/lib';
use RT;
use RT::Tickets;
RT::LoadConfig();
RT::Init();
my $tix = new RT::Tickets(RT::SystemUser);
$tix->Limit('Queue = "CustomerCare" and Status = "resolved" and Status =
"open"');
my $timeworked = {};
my %env;
while (my $ticket = $tix->Next) {
my $customer = $ticket->FirstCustomFieldValue('Environment');
unless ($customer) {warn "warning" . $ticket->id. "no profile"; next}
my $transactions = $ticket->Transactions;
while (my $transaction = $transactions->Next) {
next unless ($transaction->TimeTaken);
$timeworked =
\$env{$transaction->Creator}{$transaction->TimeTaken};
}
}
Gives me this:
[Thu Mar 15 08:16:24 2007] [error]: RestrictionsToClauses: I don't know about
yet at /usr/local/rt-3.6.3/lib/RT/Tickets_Overlay.pm line 2740.
(/usr/local/rt-3.6.3/lib/RT/Tickets_Overlay.pm:2827)
Does anyone have any insight about how I can fix this?
Mathew
--
Best regards, Ruslan.
_______________________________________________
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
