Ruby on Rails: Select from database where column equals a value from array

Question

If I have an array of IDs from a table (table1) in my database. Is there a way of querying another table (table2) to select all the records where a column equals a value equal to one of the IDs from table1.

My code so far is:

LabQuestion.where("product_id=#{Product.where(:brand_id => brand_id).pluck(:id)}")

In this code, I am trying to retrieve all the Lab Questions which are linked to all the products from a brand. This code does not work, but I've tried to demonstrate my needs.

Mischa · Accepted Answer · 2013-07-16 14:42:33Z

1

Assuming you have setup your relations properly, you can use joins to join the two tables and query them like this:

LabQuestion.joins(:product).where(:products => { :brand_id => brand_id })

answered Jul 16, 2013 at 14:42

Mischa

43.4k9 gold badges101 silver badges111 bronze badges

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

Comments

Suman Ranjan Panda · Accepted Answer · 2013-07-16 14:54:58Z

1

You can use includes instead of joins as below

LabQuestion.includes(:product).where(:products => { :brand_id => brand_id })

answered Jul 16, 2013 at 14:54

Suman Ranjan Panda

1446 bronze badges

1 Comment

Mischa Over a year ago

You can use includes, but it's not recommended in this case.

Collectives™ on Stack Overflow

Ruby on Rails: Select from database where column equals a value from array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related