[rt-users] Finding tickets that have never been worked on

[Ken Crocker]

Jerrad,

Try something like this:

my $ticket = $self->TicketObj;
my $comments = $ticket->$Transactions->Limit( FIELD => 'Type', VALUE => 
'Comment' );
my $replies = $ticket->$Transactions->Limit( FIELD => 'Type', VALUE => 
'Correspond' );

return 0 unless ($ticket->Status = 'new' &&
                        $comments &&
                        $replies);

I don't have a scrip like this, so I'm sure my syntax if off, but if you 
write one with this concept in mind, that might do it. This should give 
you any ticket that is new and has NOt had any comments or corresponence 
in it's history.
Hope this helps.

Kenn
LBNL

On 7/17/2009 11:00 PM, Jerrad Pierce wrote:
> Hi all,
>
> I'd like to be able to find tickets that have never been worked on,
> but am having difficulty doing so. In this case, no work means no
> replies sent to the user. I had not luck searching the list archives
> or wiki, but stumbled into TicketSQL on the wiki when researching
> something else and it seems to indicate that I ought to be able to
> search for: Told = NULL
>
> The proper SQL equivalent works fine on the database directly,
> but in RT 3.8.2 the search results returns 0 tickets...
>
>