From 82787bc9132869edb068904dfc8123414c115639 Mon Sep 17 00:00:00 2001 From: "mozilla%colinogilvie.co.uk" <> Date: Wed, 20 Jul 2005 05:38:14 +0000 Subject: Bug 282737: Software Error from time-tracking fields during Change Columns Patch by Joel, Me, r=wurblzap, a=myk --- Bugzilla/Search.pm | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'Bugzilla/Search.pm') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 96f38fc06..e7b7739be 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -148,6 +148,11 @@ sub init { push @supptables, "INNER JOIN components AS map_components " . "ON bugs.component_id = map_components.id"; } + + if (grep($_ =~/AS (actual_time|percentage_complete)$/, @$fieldsref)) { + push(@supptables, "INNER JOIN longdescs AS ldtime " . + "ON ldtime.bug_id = bugs.bug_id"); + } my $minvotes; if (defined $params->param('votes')) { @@ -218,11 +223,6 @@ sub init { push(@specialchart, ["keywords", $t, $params->param('keywords')]); } - if (lsearch($fieldsref, "(SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS actual_time") != -1) { - push(@supptables, "INNER JOIN longdescs AS ldtime " . - "ON ldtime.bug_id = bugs.bug_id"); - } - foreach my $id ("1", "2") { if (!defined ($params->param("email$id"))) { next; -- cgit v1.2.3-24-g4f1b