CODEWITHSUNDEEP
sqlruby-on-railshas-manyactive-relation
GhostRider
GhostRider

Reputation: 2170

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

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.

Upvotes: 1

Views: 1548

Answers (2)

Dharam Gollapudi
Dharam Gollapudi

Reputation: 6438

Did you try the following?

@users.collect(&:scores).flatten!

Upvotes: 0

mikdiet
mikdiet

Reputation: 10018

You can use 

Score.where(user: users)

This will construct sql like

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

Upvotes: 2

Related Questions