Active record query using joins

Question

I have three different models User, Order, Product:-

class User < ActiveRecord::Base
  has_many :orders
  has_many :products
end
class Product < ActiveRecord::Base
      has_many :orders
end
class Order < ActiveRecord::Base
  belongs_to :user
  belongs_to :product 
end

How to find all the products which an user has ordered using a one line active-record query?

Answer 1

This is explained in the ActiveRecord documentation:

Product.joins(:orders).where(orders: { user_id: user.id })

Answer 2

Another options here is using has_many :through relation:

Add to User model

has_many :products, through: :orders

and now user.products does the trick

Answer 3

I got it finally through this

 Product.joins(:orders).where(order: { user_id: user.id })