Rails select all users from table where

Question

I'm trying to select all users from a join table and I can't get the query right. My Models are User and Goal, which are joined by Participations. I need to list all users from Participations where the goal id = x.

@participants = User.joins(:participations).where(goal_id: @goal.parent_id)

This is not correct, because I get no such column: users.goal_id:. I can't figure out how to select all the users from the join table.

I can use @participants = @goal.participants when I'm not trying to use the goal parent id for some reason. When I do this here, I get a Couldn't find Goal without an ID error. I'm cool with a solution to either of these issues.

if @goal.parent_id?
  @parent_goal = Goal.find(params[@goal.parent_id])
  @participants = @parent_goal.participants
else
  @participants = @goal.participants
end

Goal.rb

  has_many :participations, dependent: :destroy
  has_many :participants, :through => :participations, :source => :user

User.rb

  has_many :participations, dependent: :destroy
  has_many :participant_goals, through: :participations, :source => :goal

Participation.rb

  belongs_to :user
  belongs_to :goal

Please post your models.

Alejandro Montilla
– Alejandro Montilla

2017-06-29 21:28:55 +00:00
Commented Jun 29, 2017 at 21:28 — Alejandro Montilla
– Alejandro Montilla, Commented Jun 29, 2017 at 21:28
Updated with models

ddonche
– ddonche

2017-06-29 21:35:59 +00:00
Commented Jun 29, 2017 at 21:35 — ddonche
– ddonche, Commented Jun 29, 2017 at 21:35

Ganesh · Accepted Answer · 2017-06-30 02:41:40Z

1

goal_id column is present in participations table so you need to use following query

@participants = User.joins(:participations).where('participations.goal_id = ?', @goal.parent_id)

answered Jun 30, 2017 at 2:41

Ganesh

2,0141 gold badge20 silver badges33 bronze badges

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

1 Comment

ddonche Over a year ago

That was it, much appreciated!

Collectives™ on Stack Overflow

Rails select all users from table where

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related