Find across multiple models

rubyonrails-talk
1

I have a search form that provides a param to a find condition. I have a projects model with multiple joins to other models:

has_many :accomplishments   has_many :cooperatorships   has_many :sponsorships   has_many :cooperators, :through => :cooperatorships   has_many :sponsors, :through => :sponsorships

My search when setup like this works:

def self.search(search)     if search       find(:all, :conditions => ['projects.name LIKE ?             OR projects.description LIKE ?             OR projects.leadName LIKE ?             OR sponsors.name LIKE ?',             "%#{search}%",             "%#{search}%",             "%#{search}%",             "%#{search}%"],             :include => :sponsors           )     else       scoped     end   end

If I attempt to add another include like:

:include => {:sponsors, :cooperators}

ActiveRecord reports an error that it can't find the relation and perhaps I've spelled it incorrectly.

I can switch out :sponsors for :cooperators and change the query and it finds the relation just fine.

Is it possible to do multiple joins or "includes" in this way?

Thanks, -Jim

2

I have a search form that provides a param to a find condition. I have a projects model with multiple joins to other models:

has_many :accomplishments has_many :cooperatorships has_many :sponsorships has_many :cooperators, :through => :cooperatorships has_many :sponsors, :through => :sponsorships

My search when setup like this works:

def self.search(search)    if search      find(:all, :conditions => ['projects.name LIKE ?            OR projects.description LIKE ?            OR projects.leadName LIKE ?            OR sponsors.name LIKE ?',            "%#{search}%",            "%#{search}%",            "%#{search}%",            "%#{search}%"],            :include => :sponsors          )    else      scoped    end end

If I attempt to add another include like:

:include => {:sponsors, :cooperators}

:include => [:sponsors, :cooperators]

You want an array, not a hash.

3

Philip Hallstrom wrote in post #996237: