diff options
author | Hugo Seabrook <hugo.seabrook@gmail.com> | 2013-01-30 19:05:50 +0100 |
---|---|---|
committer | Frédéric Buclin <LpSolit@gmail.com> | 2013-01-30 19:05:50 +0100 |
commit | 52deac516eb3dd1cc22f97b3a295ee856f69d354 (patch) | |
tree | 10d2d5f4fabbf00d2307ddcba63b29fc73277613 /Bugzilla/Search.pm | |
parent | 79ad758038193113a6bddfe2025bb2b916842684 (diff) | |
download | bugs-52deac516eb3dd1cc22f97b3a295ee856f69d354.tar bugs-52deac516eb3dd1cc22f97b3a295ee856f69d354.tar.gz bugs-52deac516eb3dd1cc22f97b3a295ee856f69d354.tar.bz2 bugs-52deac516eb3dd1cc22f97b3a295ee856f69d354.tar.xz bugs-52deac516eb3dd1cc22f97b3a295ee856f69d354.zip |
Bug 102048: Display the "Blocks" and "Depends On" columns in buglists
r/a=LpSolit
Diffstat (limited to 'Bugzilla/Search.pm')
-rw-r--r-- | Bugzilla/Search.pm | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 1c6af782e..658b85f99 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -468,6 +468,14 @@ sub COLUMN_JOINS { to => 'id', }, }, + blocked => { + table => 'dependencies', + to => 'dependson', + }, + dependson => { + table => 'dependencies', + to => 'blocked', + }, 'longdescs.count' => { table => 'longdescs', join => 'INNER', @@ -548,6 +556,9 @@ sub COLUMNS { . $dbh->sql_string_concat('map_flagtypes.name', 'map_flags.status')), 'keywords' => $dbh->sql_group_concat('DISTINCT map_keyworddefs.name'), + + blocked => $dbh->sql_group_concat('DISTINCT map_blocked.blocked'), + dependson => $dbh->sql_group_concat('DISTINCT map_dependson.dependson'), 'longdescs.count' => 'COUNT(DISTINCT map_longdescs_count.comment_id)', @@ -645,7 +656,9 @@ sub REPORT_COLUMNS { # is here because it *always* goes into the GROUP BY as the first item, # so it should be skipped when determining extra GROUP BY columns. use constant GROUP_BY_SKIP => qw( + blocked bug_id + dependson flagtypes.name keywords longdescs.count |