CODEWITHSUNDEEP
ruby-on-railsrubyactiverecord
randombits
randombits

Reputation: 48460

Rails, using ActiveRecord to find all rows matching a parent row attribute

I have a class Foo which has_many Bars. Foo has an attribute, some_id. I want to Retrieve all Bar instances where the Foo has some_id = N. In SQL this translates into something like:

select * from bar inner join foo on foo.id = bar.foo_id WHERE foo.some_id = N

Upvotes: 0

Views: 289

Answers (1)

x1a4
x1a4

Reputation: 19485

It would be something like:

Bar.all :joins => :foo, :conditions => {:foos => {:some_id => N}}

Upvotes: 1

Related Questions