From: Imre Farkas <ifarkas(a)redhat.com>
https://bugzilla.redhat.com/show_bug.cgi?id=770622
---
src/app/models/deployment.rb | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/src/app/models/deployment.rb b/src/app/models/deployment.rb
index 52880c0..458584a 100644
--- a/src/app/models/deployment.rb
+++ b/src/app/models/deployment.rb
@@ -440,7 +440,19 @@ class Deployment < ActiveRecord::Base
def self.apply_search_filter(search)
if search
- includes(:pool).where("pools.name ILIKE :search OR deployments.deployable_xml
ILIKE :search OR deployments.name ILIKE :search", :search =>
"%#{search}%")
+ join_statement = <<-EOS
+ LEFT OUTER JOIN
+ ( SELECT DISTINCT deployment_id, providers.name AS provider_name
+ FROM instances
+ LEFT OUTER JOIN provider_accounts ON (provider_accounts.id =
instances.provider_account_id)
+ LEFT OUTER JOIN providers ON (providers.id = provider_accounts.provider_id) )
AS deployments_providers
+ ON (deployments_providers.deployment_id = deployments.id)
+ EOS
+
+ includes(:pool).
+ joins(join_statement).
+ where("pools.name ILIKE :search OR deployments.name ILIKE :search OR
deployments_providers.provider_name ILIKE :search",
+ :search => "%#{search}%")
else
scoped
end
--
1.7.6.4