ActiveRecord join with Array of IDs

Question

The following command is useful in pulling out all Styles with a certain feature:

Style.joins(:style_features).where('style_features.feature_id= ?', 1)

Is it possible to do the same thing, but for a series of features? As in:

Style.joins(:style_features).where('style_features.feature_id= ?', [1, 2, 3])

MrYoshiji · Accepted Answer · 2014-04-16 17:45:39Z

12

You can simply do:

Style.joins(:style_features).where(style_features: { feature_id: [1, 2, 3] })

This query will let Rails deal with the SQL query depending on the DataBase Adapter you defined.

answered Apr 16, 2014 at 17:45

MrYoshiji

54.9k13 gold badges130 silver badges120 bronze badges

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

Comments

Nitin Jain · Accepted Answer · 2014-04-16 17:45:10Z

1

you can try with Style.joins(:style_features).where('style_features.feature_id in (?)', [1, 2, 3])

MrYoshiji Answer is better then me if looking at rails way

answered Apr 16, 2014 at 17:45

Nitin Jain

3,0832 gold badges27 silver badges37 bronze badges