From d49b288a6964ec98631fec08dc08d8561e2661a8 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 4 Oct 2011 06:49:07 +0000
Subject: [PATCH] fix time worked search when someone edits a value back to
 blank

---
 httemplate/search/timeworked.html | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

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
 ";
-- 
2.11.0