summaryrefslogtreecommitdiffstats
path: root/long_list.cgi
diff options
context:
space:
mode:
authorbugreport%peshkin.net <>2004-08-21 06:49:17 +0200
committerbugreport%peshkin.net <>2004-08-21 06:49:17 +0200
commit88d26275229b5f52f435130496169766313c87b7 (patch)
treec71532045500b6e2335b1e5e2512d10b8846551b /long_list.cgi
parent2f9f28d0bfb1f321d1548844a41aaf2d51789695 (diff)
downloadbugzilla-88d26275229b5f52f435130496169766313c87b7.tar.gz
bugzilla-88d26275229b5f52f435130496169766313c87b7.tar.xz
Bug 224208 Add a higher level of categorization (.ie departments, locations, etc.)
patch by Albert Ting r=joel, glob a=myk
Diffstat (limited to 'long_list.cgi')
-rwxr-xr-xlong_list.cgi9
1 files changed, 6 insertions, 3 deletions
diff --git a/long_list.cgi b/long_list.cgi
index 757d00239..515f4c226 100755
--- a/long_list.cgi
+++ b/long_list.cgi
@@ -43,6 +43,7 @@ my $generic_query = "
SELECT
bugs.bug_id,
COALESCE(bugs.alias, ''),
+ classifications.name,
products.name,
bugs.version,
bugs.rep_platform,
@@ -63,9 +64,10 @@ my $generic_query = "
bugs.estimated_time,
bugs.remaining_time,
date_format(creation_ts,'%Y.%m.%d %H:%i')
- FROM bugs,profiles assign,profiles report, products, components
+ FROM bugs,profiles assign,profiles report, classifications, 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";
+ AND bugs.product_id=products.id AND bugs.component_id=components.id
+ AND products.classification_id = classifications.id";
my $buglist = $cgi->param('buglist') ||
$cgi->param('bug_id') ||
@@ -81,7 +83,8 @@ foreach my $bug_id (split(/[:,]/, $buglist)) {
my %bug;
my @row = FetchSQLData();
- foreach my $field ("bug_id", "alias", "product", "version", "rep_platform",
+ foreach my $field ("bug_id", "alias", "classification", "product",
+ "version", "rep_platform",
"op_sys", "bug_status", "resolution", "priority",
"bug_severity", "component", "assigned_to", "reporter",
"bug_file_loc", "short_desc", "target_milestone",