diff options
| author | bbaetz%student.usyd.edu.au <> | 2002-08-12 14:42:42 +0200 |
|---|---|---|
| committer | bbaetz%student.usyd.edu.au <> | 2002-08-12 14:42:42 +0200 |
| commit | 61ddf0a32846fdf2607043d94af1a0a86b80f6fc (patch) | |
| tree | 714517b4c6b9e33b10a12aa5a4b99641bcafefef /long_list.cgi | |
| parent | 17b301e76d886afd5be8f4e9919afb4446e49405 (diff) | |
| download | bugzilla-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.tar.gz bugzilla-61ddf0a32846fdf2607043d94af1a0a86b80f6fc.tar.xz | |
Bug 43600 - Convert products/components to use ids instead of names.
Initial attempt by jake@bugzilla.org, updated by me
r=joel, preed
Diffstat (limited to 'long_list.cgi')
| -rwxr-xr-x | long_list.cgi | 9 |
1 files changed, 5 insertions, 4 deletions
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'} || |