From 830eca78e2f0e5526ff6d5c9ada3239b9175d4b4 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Mon, 29 Aug 2005 00:52:00 +0000
Subject: Bug 306117: Search on "Percentage Completed" field returns "unknown
 column 'bugs.remaining_time' in 'having clause'" - Patch by Lance Larsh
 <lance.larsh@oracle.com> r=joel a=justdave

---
 Bugzilla/Search.pm | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 64342d17c..ae11dfa67 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -732,6 +732,9 @@ sub init {
              }
              if ($oper ne "noop") {
                  my $table = "longdescs_$chartid";
+                 if(lsearch(\@fields, "bugs.remaining_time") == -1) {
+                     push(@fields, "bugs.remaining_time");                  
+                 }
                  push(@supptables, "INNER JOIN longdescs AS $table " .
                                    "ON $table.bug_id = bugs.bug_id");
                  my $expression = "(100 * ((SUM($table.work_time) *
-- 
cgit v1.2.3-24-g4f1b