Rails Nested Joins

Question

Manufacturer

has_many :product

Product

has_many :part

PartsRequest

belongs_to :part belongs_to :manufacturer

I am trying to do something in PartsRequest e.g. Manufacturer A is trying to request for Parts from Manufacturer B

scope :incoming_requests, lambda { |manufacturer_id| joins(:part).joins(product).where("product.manufacturer_id = ?", manufacturer_id) }

How do I join to parts, then from parts join with products?

Are you just looking for joins(:part => :product) or is it more complex than that? — mnelson
– mnelson, Commented Nov 10, 2011 at 6:54

mnelson · Accepted Answer · 2011-11-10 07:37:45Z

4

scope :incoming_requests, lambda{|mid| joins(:part => :product).where(:product => {:manufacturer_id => mid}) }

answered Nov 10, 2011 at 7:37

3,0221 gold badge19 silver badges19 bronze badges

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

1 Answer 1