Possible to search nested/polymorphic models? about search_cop HOT 3 CLOSED

  search_scope :search do
    attributes :user => ["users.first_name", "users.last_name", "users.email"]

    scope do
      joins("left outer join users on (users.meta_id = client_id and meta_type = 'Client') or (users.meta_id = coach_id and meta_type = 'Coach')").group(:id)
    end 
  end 

  search_scope :search do
    attributes :client => ["client_user.first_name", "client_user.last_name", "client_user.email"]
    attributes :coach => ["coach_user.first_name", "coach_user.last_name", "coach_user.email"]

    scope do
      joins("left outer join users client_user on (client_user.meta_id = client_id and client_user.meta_type = 'Client') left outer join users coach_user on (coach_user.meta_id = coach_id and coach_user.meta_type = 'Coach')")
    end 

    aliases :client_user => :user, :coach_user => :user
  end