From d0a494ac3dba413373c3f8978fad93c4cc28e19f Mon Sep 17 00:00:00 2001 From: "dkl%redhat.com" <> Date: Wed, 24 Sep 2008 21:33:22 +0000 Subject: [PATCH] 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(-) diff --git a/buglist.cgi b/buglist.cgi index d40cbaa7ae..206d9651d9 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -1205,9 +1205,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 ' -- 2.47.2