ruby-on-railsmeta-where

why am I getting a metawhere join dependency error in Rails 3?

I get a metawhere join dependency error with the following:

@companies_user = Company.joins(:contact).where(:contact => {:user_id => current_user.id}).uniq

Company has_many contacts

In other words, every Contact has a method company_id

I want to show those companies (only one) where the contacts have a user_id equal to that of the user doing the search.

Solution

  • Well, if your company has many contacts then you should include contacts not contact

    @companies_user = Company.joins(:contacts).where(:contacts => {:user_id => current_user.id}).uniq