Change from .joins to .includes breaking resulting in error

[simkessy]

I had this working query:

@search = Availability.joins{facility.activities}
.where{activities.id == s_activity}

But my view was getting a lot of information from Facilities and this resulted in an N+1 issue.

So I decided I should be using includes instead to eager load my associations

@search = Availability.includes{facility.activities}
.where{ facility.activities.id == s_activity)}

But this results in an error:

!! #<ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "activities"
LINE 1: ...T "availabilities".* FROM "availabilities" WHERE ("activitie...
                                                             ^

These are the associations:

class Activity < ActiveRecord::Base
  has_and_belongs_to_many :facilities
end

class Availability < ActiveRecord::Base
  # Associations
  belongs_to :facility
end

class Facility < ActiveRecord::Base
  #  Associations
  has_and_belongs_to_many :activities
  has_many :availabilities

end

There's a table called activities_facilities for the has_and_belongs_to_many

[simkessy]

I needed to add .references I missed that in the documentation.