diff options
author | ivan <ivan> | 2010-09-29 19:54:55 +0000 |
---|---|---|
committer | ivan <ivan> | 2010-09-29 19:54:55 +0000 |
commit | 64cff83a723d02a3064e08d4e69c13f9b43fed58 (patch) | |
tree | a30a8b55582ac93d13d1d02de8ccbe9635071e0e | |
parent | 700eefaade6c281ef921965543e71534cd78a84d (diff) |
fix time worked search by customer
-rw-r--r-- | httemplate/search/rt_transaction.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html index 8bf193c9a..fb828af84 100644 --- a/httemplate/search/rt_transaction.html +++ b/httemplate/search/rt_transaction.html @@ -90,7 +90,7 @@ if ( $cgi->param('ticketid') =~ /^\s*(\d+)\s*$/ ) { } if ( $cgi->param('svcnum') =~ /^\s*(\d+)\s*$/ ) { - $where .= " AND acct_rt_transaction.svcnum = $1"; + $where .= " AND EXISTS( SELECT 1 FROM acct_rt_transaction WHERE acct_rt_transaction.transaction_id = Transactions.id AND svcnum = $1 )"; } my $query = { @@ -100,7 +100,7 @@ my $query = { 'Tickets.Subject', 'Users.name AS otaker', "$transactiontime AS transaction_time", - '( SELECT SUM(support) from acct_rt_transaction where Transaction_id = Transactions.id ) AS support', + '( SELECT SUM(support) from acct_rt_transaction where transaction_id = Transactions.id ) AS support', ), 'table' => 'transactions', #Pg-ism #'table' => 'Transactions', |