Rails: Getting all has_many objects associated with an active relation of parents

Question

I have what I suspect is a basic question. In my rails app, One user has many scores. Is there a way to get all the scores of an active relation of users. I can do user.scores (obviously) but if users is a group of users I need to do something like users.scores. This is clearly not correct.

Answer 1

You can use

Score.where(user: users)

This will construct sql like

select * from scores where user_id in (select *.id from users where ..)