diff options
| author | ivan <ivan> | 2011-10-04 06:49:06 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-10-04 06:49:06 +0000 |
| commit | bd9ef4c4ca8644f99c1fcc595212f6a5c6787fc5 (patch) | |
| tree | 711aea0f7e4d4b5ff9e967568b891f41b8c69594 | |
| parent | 1551c7d41cea8bfa58ea1d3fb489cfb54823e5d8 (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 "; |