X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FTicketSystem%2FRT_External.pm;h=3bb1991f5c4d4c432d32f108087631b5c39fa137;hb=7114ddae6f6595d72b7e17cdaefb9d7f915a8b7b;hp=26420ded77bc4f57d918c950427c1f264fd13da9;hpb=30fcc76ecfc50dc299bbb86a217f88ffa7de5b64;p=freeside.git

diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm
index 26420ded7..3bb1991f5 100644
--- a/FS/FS/TicketSystem/RT_External.pm
+++ b/FS/FS/TicketSystem/RT_External.pm
@@ -50,7 +50,8 @@ sub num_customer_tickets {
   }
 
   my $sql = "
-    select count(*) from tickets 
+    select count(*) from tickets
+                    join links on ( tickets.id = links.localbase )
        where ( status = 'new' or status = 'open' or status = 'stalled' )
          and target = 'freeside://freeside/cust_main/$custnum'
          $priority_sql