From 13642dbe5958968806636a75c1ffa3e056671f86 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Wed, 16 Nov 2005 09:03:52 +0000
Subject: Bug 288557: Show in the request queue those requests tied to secure
 bugs for which the user is the QA contact - Patch by Frédéric Buclin
 <LpSolit@gmail.com> r/a=myk
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 request.cgi | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'request.cgi')

diff --git a/request.cgi b/request.cgi
index 689615b32..c60e9cc1f 100755
--- a/request.cgi
+++ b/request.cgi
@@ -107,9 +107,9 @@ sub queue {
                   ON flags.requestee_id  = requestees.userid
           INNER JOIN bugs
                   ON flags.bug_id = bugs.bug_id
-           LEFT JOIN products
+          INNER JOIN products
                   ON bugs.product_id = products.id
-           LEFT JOIN components
+          INNER JOIN components
                   ON bugs.component_id = components.id
            LEFT JOIN bug_group_map AS bgmap
                   ON bgmap.bug_id = bugs.bug_id
@@ -124,7 +124,9 @@ sub queue {
     " WHERE     ((bgmap.group_id IS NULL) OR
                  (ccmap.who IS NOT NULL AND cclist_accessible = 1) OR
                  (bugs.reporter = $userid AND bugs.reporter_accessible = 1) OR
-                 (bugs.assigned_to = $userid))";
+                 (bugs.assigned_to = $userid) " .
+                 (Param('useqacontact') ? "OR
+                 (bugs.qa_contact = $userid))" : ")");
     
     # Non-deleted flags only
     $query .= " AND flags.is_active = 1 ";
-- 
cgit v1.2.3-24-g4f1b