projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
30fcc76
)
... and this last piece of sql too
author
ivan
<ivan>
Mon, 6 Dec 2004 14:15:34 +0000
(14:15 +0000)
committer
ivan
<ivan>
Mon, 6 Dec 2004 14:15:34 +0000
(14:15 +0000)
FS/FS/TicketSystem/RT_External.pm
patch
|
blob
|
history
diff --git
a/FS/FS/TicketSystem/RT_External.pm
b/FS/FS/TicketSystem/RT_External.pm
index
26420de
..
3bb1991
100644
(file)
--- 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