diff options
| author | ivan <ivan> | 2011-10-04 06:49:07 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-10-04 06:49:07 +0000 |
| commit | d49b288a6964ec98631fec08dc08d8561e2661a8 (patch) | |
| tree | 8edd9be3da37dd6721f652567dde04842a5189a3 | |
| parent | d59081d27225478c3b0776f2ea0d0587f714f90b (diff) | |
fix time worked search when someone edits a value back to blank
| -rw-r--r-- | httemplate/search/timeworked.html | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/httemplate/search/timeworked.html b/httemplate/search/timeworked.html index d07cd4f59..e810822d7 100644 --- a/httemplate/search/timeworked.html +++ b/httemplate/search/timeworked.html @@ -45,7 +45,9 @@ my @groupby = (); my $transactiontime = " CASE Transactions.Type WHEN 'Set' - THEN (TO_NUMBER(NewValue,'999999')-TO_NUMBER(OldValue, '999999')) * 60 + THEN ( CASE WHEN NewValue = '' THEN 0 ELSE TO_NUMBER(NewValue,'999999') END + -TO_NUMBER(OldValue, '999999') + ) * 60 ELSE TimeTaken*60 END "; |