From 3ca52bba011446c4e2d897f98847c2c3d4ea51cd Mon Sep 17 00:00:00 2001
From: "gerv%gerv.net" <>
Date: Wed, 11 Sep 2002 20:56:35 +0000
Subject: Bug 166821 - reports.cgi broken by recent schema changes. r=bbaetz.

---
 reports.cgi | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

(limited to 'reports.cgi')

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
-- 
cgit v1.2.3-24-g4f1b