1 package FS::TicketSystem::RT_Internal;
6 @ISA = qw( FS::TicketSystem::RT_Libs );
8 sub sql_customer_tickets {
9 "( select count(*) from tickets
10 join links on ( tickets.id = links.localbase )
11 where ( status = 'new' or status = 'open' or status = 'stalled' )
12 and target = 'freeside://freeside/cust_main/' || custnum