From 42df314211a555051fec00038be43459ceb745a8 Mon Sep 17 00:00:00 2001
From: Alexei Volkov <Alexei.Volkov@softlynx.ru>
Date: Tue, 18 Oct 2011 23:37:05 +0200
Subject: [PATCH] Bug 686860: Correctly calculate Hours Worked in buglists
 r/a=mkanat

---
 Bugzilla/Search.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 2e43d8273a..58e8290269 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -296,7 +296,7 @@ sub COLUMNS {
     # Next we define columns that have special SQL instead of just something
     # like "bugs.bug_id".
     my $actual_time = '(SUM(ldtime.work_time)'
-        . ' * COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))';
+        . ' * COUNT(DISTINCT ldtime.comment_id)/COUNT(bugs.bug_id))';
     my %special_sql = (
         deadline    => $dbh->sql_date_format('bugs.deadline', '%Y-%m-%d'),
         actual_time => $actual_time,
-- 
2.47.2