Issue regarding fetching some records from table in rails

Question

I have a User model. Now I have an array named id_array containing certain ids such as:

id_array=[123,145,229]

Now is there any rails way to get only those records from users table with these matching ids in id_array by using active record query?

I don't want to write a do-each loop to achieve this. I just want a single active record query which will give the result.

Please help me if there is a way. Thanks in advance!!

razvans · Accepted Answer · 2018-02-08 12:05:30Z

1

Passing an array for a column translates to WHERE id IN (id1, id2, id3) in sql. all triggers the query and returns the results.

User.where(id: id_array).all

answered Feb 8, 2018 at 11:13

razvans

3,2727 gold badges25 silver badges31 bronze badges

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

1 Comment

@7urkm3n Updated. Thanks.

Marek Lipka · Accepted Answer · 2018-02-08 11:14:25Z

0

There is a way, you can simply pass ruby Array to your ActiveRecord query, like this:

User.where(id: id_array)

answered Feb 8, 2018 at 11:14

Marek Lipka

51.3k7 gold badges90 silver badges93 bronze badges