ticket search

[rvaldomir]

Hi,

I want to show ticket in a widget that matches with some conditions, example no service, no ticket type or no dynamic field is filled.

a.png

now I can use the ticketSearch but does not provide the negative to search.

It is possible to use a sql query?

my %TicketSearchSummary = (
"Uncategorized Tickets"=> {
OwnerIDs => [ $Self->{UserID}, ],
Locks => undef,
StateType => [ 'new', 'open', 'pending reminder', 'pending auto' ],
# SQL HERE TO FILTER SOME OTHER CONDITION

},
);