diff options
| author | ivan <ivan> | 2010-04-07 06:20:53 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2010-04-07 06:20:53 +0000 |
| commit | c354e082415cd3fe1c48301bd2d5e75af5efedcc (patch) | |
| tree | a5cd791ffd4d1299eb73e9d8e6c1cbc86a904243 /FS/FS/TicketSystem | |
| parent | 91e7650c03c9194ee2fee6334699203f31efa7ce (diff) | |
fix capitalization of RT tables and columns - mysql fix
Diffstat (limited to 'FS/FS/TicketSystem')
| -rw-r--r-- | FS/FS/TicketSystem/RT_Internal.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/FS/TicketSystem/RT_Internal.pm b/FS/FS/TicketSystem/RT_Internal.pm index b1121ef..f47648e 100644 --- a/FS/FS/TicketSystem/RT_Internal.pm +++ b/FS/FS/TicketSystem/RT_Internal.pm @@ -15,10 +15,10 @@ $DEBUG = 0; $me = '[FS::TicketSystem::RT_Internal]'; sub sql_num_customer_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 + "( 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 )"; } |