summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorgerv%gerv.net <>2002-09-11 22:56:35 +0200
committergerv%gerv.net <>2002-09-11 22:56:35 +0200
commit3ca52bba011446c4e2d897f98847c2c3d4ea51cd (patch)
treee6ed499d77a53dc2bb9e02caf23309dbd60c7597
parentd7b93f801f37f050959058eb48f5e58686e78254 (diff)
downloadbugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.tar.gz
bugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.tar.xz
Bug 166821 - reports.cgi broken by recent schema changes. r=bbaetz.
-rwxr-xr-xreports.cgi9
1 files changed, 7 insertions, 2 deletions
diff --git a/reports.cgi b/reports.cgi
index f557ac7f6..13c8406ee 100755
--- a/reports.cgi
+++ b/reports.cgi
@@ -769,9 +769,14 @@ sub most_recently_doomed {
#########################
# Build up $query string
- my $query = "select distinct assigned_to from bugs where bugs.bug_status='NEW' and target_milestone='' and bug_severity!='enhancement' and status_whiteboard='' and (product='Browser' or product='MailNews')";
+ my $query = "SELECT DISTINCT assigned_to FROM bugs, products
+ WHERE bugs.bug_status = 'NEW'
+ AND target_milestone = ''
+ AND bug_severity != 'enhancement'
+ AND status_whiteboard = ''
+ AND bugs.product_id = products.id";
if ($FORM{'product'} ne "-All-" ) {
- $query .= "and bugs.product=".SqlQuote($FORM{'product'});
+ $query .= "AND products.name =".SqlQuote($FORM{'product'});
}
# End build up $query string