From 61ddf0a32846fdf2607043d94af1a0a86b80f6fc Mon Sep 17 00:00:00 2001
From: "bbaetz%student.usyd.edu.au" <>
Date: Mon, 12 Aug 2002 12:42:42 +0000
Subject: Bug 43600 - Convert products/components to use ids instead of names.
 Initial attempt by jake@bugzilla.org, updated by me r=joel, preed

---
 long_list.cgi | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'long_list.cgi')

diff --git a/long_list.cgi b/long_list.cgi
index 33975f5b1..933e90f15 100755
--- a/long_list.cgi
+++ b/long_list.cgi
@@ -41,7 +41,7 @@ GetVersionTable();
 my $generic_query = "
   SELECT 
     bugs.bug_id, 
-    bugs.product, 
+    products.name, 
     bugs.version, 
     bugs.rep_platform,
     bugs.op_sys, 
@@ -49,7 +49,7 @@ my $generic_query = "
     bugs.resolution, 
     bugs.priority,
     bugs.bug_severity, 
-    bugs.component, 
+    components.name, 
     assign.login_name, 
     report.login_name,
     bugs.bug_file_loc, 
@@ -58,8 +58,9 @@ my $generic_query = "
     bugs.qa_contact, 
     bugs.status_whiteboard, 
     bugs.keywords
-  FROM bugs,profiles assign,profiles report
-  WHERE assign.userid = bugs.assigned_to AND report.userid = bugs.reporter";
+  FROM bugs,profiles assign,profiles report, products, components
+  WHERE assign.userid = bugs.assigned_to AND report.userid = bugs.reporter
+    AND bugs.product_id=products.id AND bugs.component_id=components.id";
 
 my $buglist = $::FORM{'buglist'} || 
               $::FORM{'bug_id'}  || 
-- 
cgit v1.2.3-24-g4f1b