Ruby Rails Query In conditional

Question

I have this query that works but I would like to expand it so that I can check for multiple ids such that I pass in a vector of ids. [1,2,3,5] etc... I have tried using SQL IN with no luck.

EventType.find(3).events.all(:include => {:sheet => :rink}, :conditions => ["rinks.id = ?", 2])

rep · Accepted Answer · 2013-07-30 18:10:09Z

1

You were on the right track with IN. Here's syntax that will work in Rails 3+:

EventType.find(3).events.where("id IN (?)", [1,2,3]).include(:sheet => :rink)

Improvement from a comment removes SQL entirely:

EventType.find(3).events.where(:id => [1,2,3]).include(:sheet => :rink)

edited Jul 30, 2013 at 18:10

answered Jul 30, 2013 at 16:48

rep

1,8441 gold badge15 silver badges20 bronze badges

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

2 Comments

user2434674 Over a year ago

Thanks, I was missing the parenthesis around ?

mu is too short Over a year ago

You could also where(:id => [1,2,3])

Collectives™ on Stack Overflow

Ruby Rails Query In conditional

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related