diff options
| author | ivan <ivan> | 2007-09-13 22:35:20 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2007-09-13 22:35:20 +0000 |
| commit | db18a813b59b8254ff19f77770750a781613d79e (patch) | |
| tree | da94fc86ca1b595cdfda073d10e25d2b3188e3cf /httemplate/search/timeworked.html | |
| parent | 24a360f232fb25bfc1e1285575b4a55a5e350c21 (diff) | |
rename svc_acct_rt_transaction to acct_rt_transaction, as it is not a service, its something that hangs off of an svc_acct (like an acct_snarf). thank goodness was able to do this before its any sort of migration problem...
Diffstat (limited to 'httemplate/search/timeworked.html')
| -rw-r--r-- | httemplate/search/timeworked.html | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/httemplate/search/timeworked.html b/httemplate/search/timeworked.html index 18af74641..858cc6281 100644 --- a/httemplate/search/timeworked.html +++ b/httemplate/search/timeworked.html @@ -55,9 +55,9 @@ push @groupby, "newvalue"; push @groupby, "oldvalue"; push @groupby, "timetaken"; -my $appliedtimeclause = "coalesce (sum(svc_acct_rt_transaction.seconds), 0)"; +my $appliedtimeclause = "coalesce (sum(acct_rt_transaction.seconds), 0)"; -my $appliedtimeselect = "SELECT sum(seconds) FROM svc_acct_rt_transaction where transaction_id = transactions.id"; +my $appliedtimeselect = "SELECT sum(seconds) FROM acct_rt_transaction where transaction_id = transactions.id"; push @groupby, "transactions.id"; my $wheretimeleft = "($transactiontime != ($appliedtimeselect) OR ($appliedtimeselect) is NULL)"; @@ -68,7 +68,7 @@ push @groupby, "transactions.created"; my $groupby = join(',', @groupby); -my $query = "SELECT tickets.id,tickets.subject,to_char(transactions.created, 'Dy Mon DD HH24:MI:SS YYYY'),$transactiontime-$appliedtimeclause,transactions.id FROM transactions JOIN tickets ON transactions.objectid = tickets.id LEFT JOIN svc_acct_rt_transaction on transactions.id = svc_acct_rt_transaction.transaction_id WHERE objecttype='RT::Ticket' AND ((transactions.type='Set' AND field='TimeWorked') OR transactions.type='Comment' OR transactions.type='Correspond') AND ($wheretimeleft) GROUP BY $groupby ORDER BY transactions.created"; +my $query = "SELECT tickets.id,tickets.subject,to_char(transactions.created, 'Dy Mon DD HH24:MI:SS YYYY'),$transactiontime-$appliedtimeclause,transactions.id FROM transactions JOIN tickets ON transactions.objectid = tickets.id LEFT JOIN acct_rt_transaction on transactions.id = acct_rt_transaction.transaction_id WHERE objecttype='RT::Ticket' AND ((transactions.type='Set' AND field='TimeWorked') OR transactions.type='Comment' OR transactions.type='Correspond') AND ($wheretimeleft) GROUP BY $groupby ORDER BY transactions.created"; my $count_query = "SELECT count(*) FROM transactions WHERE objecttype='RT::Ticket' AND ((transactions.type='Set' AND field='TimeWorked') OR transactions.type='Comment' OR transactions.type='Correspond') AND ($wheretimeleft)"; </%init> |