this works perfectly.
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: Tuesday, June 12, 2012 9:02 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search Ticket Transaction History
On 06/13/2012 04:15 PM, Brian Schrock wrote:
Custom Condition:
my $txn = $self-TransactionObj;
my $type = $txn-Type;
unless (
($type eq Status) ||
($type eq 'Set' $txn-Field eq 'Status') ||
($txn-OldValue eq resolved) ||
($txn-OldValue eq stalled) ||
($txn-NewValue
-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: Wednesday, June 13, 2012 4:23 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search Ticket Transaction History in Query Builder?
On 06/13/2012 04:15 PM, Brian Schrock
-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Brian Schrock
Sent: Wednesday, June 13, 2012 4:24 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search Ticket Transaction History in Query Builder?
Yep, I was just
This is not available in the query builder. I asked the same question a while
back and basically the query builder works on the tickets taw only and cannot
do cross queries. I ended up writing a shell script for my needs which
basically was any update performed by any member of a particular
SELECT Tickets.id, Tickets.Created, Tickets.Subject, Tickets.Status,
Queues.Name
FROM Transactions, Tickets, Queues
WHERE
Tickets.Queue=Queues.id
AND Queues.Name=Test Queue 1
AND Tickets.Status='open'
AND Transactions.ObjectId=Tickets.id
AND Transactions.OldValue REGEXP stalled|resolved
