diff options
| author | ivan <ivan> | 2004-12-06 14:15:34 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-12-06 14:15:34 +0000 |
| commit | 7114ddae6f6595d72b7e17cdaefb9d7f915a8b7b (patch) | |
| tree | 73016cf9ea0df45a83ceea531773e14005015667 /FS/FS/TicketSystem | |
| parent | 30fcc76ecfc50dc299bbb86a217f88ffa7de5b64 (diff) | |
... and this last piece of sql too
Diffstat (limited to 'FS/FS/TicketSystem')
| -rw-r--r-- | FS/FS/TicketSystem/RT_External.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/FS/FS/TicketSystem/RT_External.pm b/FS/FS/TicketSystem/RT_External.pm index 26420de..3bb1991 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 |