From d488859bea5acf8406ff19465c1187950105ac05 Mon Sep 17 00:00:00 2001
From: Fabrice Bellingard <bellingard@gmail.com>
Date: Tue, 26 Apr 2011 14:59:17 +0200
Subject: [PATCH] SONAR-1973 Fix bug in DB request

---
 .../webapp/WEB-INF/app/controllers/resource_controller.rb   | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/sonar-server/src/main/webapp/WEB-INF/app/controllers/resource_controller.rb b/sonar-server/src/main/webapp/WEB-INF/app/controllers/resource_controller.rb
index 72893127e98..910a52c5594 100644
--- a/sonar-server/src/main/webapp/WEB-INF/app/controllers/resource_controller.rb
+++ b/sonar-server/src/main/webapp/WEB-INF/app/controllers/resource_controller.rb
@@ -175,14 +175,14 @@ class ResourceController < ApplicationController
     conditions='snapshot_id=?'
     values=[@snapshot.id]
     if params[:rule].blank?
-      conditions+='AND (switched_off IS NULL OR switched_off=?)'
+      conditions+=' AND (switched_off IS NULL OR switched_off=?)'
       values<<false
     else
       if params[:rule] == "f-positive"
-        conditions+='AND switched_off=?'
+        conditions+=' AND switched_off=?'
         values<<true
       else
-        conditions+='AND (switched_off IS NULL OR switched_off=?)'
+        conditions+=' AND (switched_off IS NULL OR switched_off=?)'
         values<<false
         severity=Sonar::RulePriority.id(params[:rule])
         if severity
-- 
2.39.5