From cdb5a5b60273f5e00b5e7a3e05c28bd6da2fa467 Mon Sep 17 00:00:00 2001 From: "dkl%redhat.com" <> Date: Wed, 24 Sep 2008 21:27:31 +0000 Subject: Bug 456642 - Mass bug edit form for buglist.cgi shows inactive bug statuses in drop down Patch by David Lawrence - r/a=LpSolit --- buglist.cgi | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'buglist.cgi') diff --git a/buglist.cgi b/buglist.cgi index d762dd5ee..f83f957fc 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -1221,9 +1221,12 @@ if ($dotweak && scalar @bugs) { # It also accepts transitions where the bug status doesn't change. $bug_status_ids = $dbh->selectcol_arrayref( - 'SELECT DISTINCT new_status + 'SELECT DISTINCT sw1.new_status FROM status_workflow sw1 - WHERE NOT EXISTS + INNER JOIN bug_status + ON bug_status.id = sw1.new_status + WHERE bug_status.isactive = 1 + AND NOT EXISTS (SELECT * FROM status_workflow sw2 WHERE sw2.old_status != sw1.new_status AND ' -- cgit v1.2.3-24-g4f1b