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

Question

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.

score 0 · Answer 1 · answered Oct 22 '11 at 09:47

0

Why not doing it this way?

current_user.contact.companies

Then you can use .limit to only fetch one...

answered Oct 22 '11 at 09:47

davidb

how does this work, it would list only the companies once if I use .limit? – Satchel Oct 24 '11 at 04:34

score 0 · Accepted Answer · answered Oct 22 '11 at 15:47

0

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

answered Oct 22 '11 at 15:47

dombesz

2 Answers2