From b66dedd512a994882f51496a7436cf3bc028a8d6 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Wed, 28 Sep 2005 05:18:08 +0000 Subject: Bug 309896: The "Saved searches" tab in User Prefs can report incorrect information - Patch by A. Karl Kornel r=LpSolit a=justdave --- Bugzilla/User.pm | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'Bugzilla/User.pm') diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm index f5aae89e1..fa924bf05 100644 --- a/Bugzilla/User.pm +++ b/Bugzilla/User.pm @@ -198,13 +198,19 @@ sub queries { my $dbh = Bugzilla->dbh; my $sth = $dbh->prepare(q{ SELECT DISTINCT name, query, linkinfooter, - CASE WHEN whine_queries.id - IS NOT NULL THEN 1 ELSE 0 END, + CASE WHEN whine_queries.id IS NOT NULL + THEN 1 ELSE 0 END, UPPER(name) AS uppername FROM namedqueries + LEFT JOIN whine_events + ON whine_events.owner_userid = + namedqueries.userid LEFT JOIN whine_queries - ON whine_queries.query_name = name - WHERE userid=? + ON whine_queries.query_name = + namedqueries.name + AND whine_queries.eventid = + whine_events.id + WHERE namedqueries.userid=? ORDER BY uppername}); $sth->execute($self->{id}); -- cgit v1.2.3-24-g4f1b