Rails Join Query Error

Question

i'm struggling to make a query that shows the friends of user that have activities in a city. The variable @friends has the friends of the user, and i want to make a join with activities and and places because i want to filter the results by city. A account(user) has many activities and also has many places though activities. I'm having the following error:

SQLite3::SQLException: no such column: accounts.city:

   def show
        @friends = Account.find(current_account.id).active_friends
        @nearbyFriends = @friends.joins(:activities,:places).where(:city => @place.city).group(:account_id)
      end

blelump · Accepted Answer · 2014-11-16 19:04:43Z

1

Try:

def show
  # ...
  @nearbyFriends = @friends.joins(:activities,:places).where(:places => { :city => @place.city }).group(:account_id)
end

When using joins, any field in where clause must contain table name it comes from. The same applies to group (if friends table doesn't contain account_id).

edited Nov 16, 2014 at 19:04

answered Nov 16, 2014 at 18:57

blelump

3,2431 gold badge18 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Miguel Morujão Over a year ago

SQLite3::SQLException: ambiguous column name: account_id

blelump Over a year ago

Which one of your tables contain account_id?

blelump Over a year ago

Then as I told you, the same applies to group, so in this case group("activities.account_id").

Collectives™ on Stack Overflow

Rails Join Query Error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related