summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorterry%mozilla.org <>2000-01-17 20:45:34 +0100
committerterry%mozilla.org <>2000-01-17 20:45:34 +0100
commit9dd61f718a075a1f97aa0926e1110801edf4154b (patch)
treed25078a4981d3f7e3894afa1a5febe0c4f9e2d39
parent9178b8f1a5722ad7957b33ffb6f8b9ef40c8f394 (diff)
downloadbugzilla-9dd61f718a075a1f97aa0926e1110801edf4154b.tar.gz
bugzilla-9dd61f718a075a1f97aa0926e1110801edf4154b.tar.xz
Use new "keywords" cache to display keywords in bug lists. Not only
is this much faster, but it also lets you sort by that column, and requires less special-case code.
-rwxr-xr-xbuglist.cgi16
1 files changed, 1 insertions, 15 deletions
diff --git a/buglist.cgi b/buglist.cgi
index 28f71098d..86fad102e 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -182,6 +182,7 @@ DefCol("os", "substring(bugs.op_sys, 1, 4)", "OS", "bugs.op_sys");
DefCol("target_milestone", "bugs.target_milestone", "TargetM",
"bugs.target_milestone");
DefCol("votes", "bugs.votes", "Votes", "bugs.votes desc");
+DefCol("keywords", "bugs.keywords", "Keywords", "bugs.keywords");
my @collist;
if (defined $::COOKIE{'COLUMNLIST'}) {
@@ -570,8 +571,6 @@ foreach my $c (@collist) {
} else {
$tablestart .= $::title{$c};
}
- } elsif ($c eq "keywords") {
- $tablestart .= "<TH valign=left>Keywords</TH>";
}
}
@@ -657,19 +656,6 @@ while (@row = FetchSQLData()) {
$value = "<nobr>$value</nobr>";
}
pnl "<td class=$c>$value";
- } elsif ($c eq "keywords") {
- my $query =
- $::db->query("SELECT keyworddefs.name
- FROM keyworddefs, keywords
- WHERE keywords.bug_id = $bug_id
- AND keyworddefs.id = keywords.keywordid
- ORDER BY keyworddefs.name");
- my @list;
- my @row;
- while (@row= $query->fetchrow()) {
- push(@list, $row[0]);
- }
- pnl("<td>" . join(", ", @list) . "</td>");
}
}
if ($dotweak) {