ActiveRecord where field = ? array of possible values

Question

I want to do

Model.where('id = ?', [array of values])

How do I accomplish this look up without chaining OR statements together?

score 207 · Accepted Answer · edited May 23 '17 at 11:55

207

From here it appears to be done using an SQL in statement:

Model.where('id IN (?)', [array of values])

Or more simply, as kdeisz pointed out (Using Arel to create the SQL query):

Model.where(id: [array of values])

edited May 23 '17 at 11:55

Community

1
1

answered Mar 10 '15 at 01:06

Will Richardson

7,780
7
42
56

10

This can be simplified to `Model.where(id: [array of values])` – kddeisz Mar 10 '15 at 02:52
Model.where("id in (?)", [1..8]) does not seemt o be working for me. any ideas? – BenKoshy Sep 22 '16 at 05:42
You don't need the square brackets, `1..8` is already array-like. – Will Richardson Sep 22 '16 at 10:27
1

Will this syntax automatically escape single quotes within the [array of values]? – WiredIn Jul 01 '17 at 17:53
1

When my array is big enough, the method expend a lot of time. How could you do that with really big arrays? – jgomo3 Apr 04 '19 at 20:48

messanjah · Answer 2 · 2019-04-25T05:02:49.797

22

From the ActiveRecord Query Interface guide

If you want to find records using the IN expression you can pass an array to the conditions hash:

Client.where(orders_count: [1,3,5])

edited Apr 25 '19 at 05:02

answered Mar 10 '15 at 03:17

messanjah

8,977
4
27
40

The link in this answer is currently not working, should be https://guides.rubyonrails.org/active_record_querying.html#subset-conditions – kangkyu Apr 25 '19 at 01:33

score 6 · Answer 3 · answered May 10 '17 at 09:17

6

For readability, this can be simplified even further, to:

Model.find_by(id: [array of values])

This is equivalent to using where, but more explicit:

Model.where(id: [array of values])

answered May 10 '17 at 09:17

Selfish

6,023
4
44
63

1

`find_by` actually is `where().take`. `Model.find_by(id: [1, 2, 3])` will only return `Model(id: 1)` – James.Oliver Jun 07 '19 at 01:20
another option if looking for just a single record instead of the array that meets the criteria, `find_by_id([1, 2, 3])` – Steve Apr 27 '20 at 21:26

score 3 · Answer 4 · answered Jan 22 '20 at 14:02

3

You can use the 'in' operator:

Model.in(id: [array of values])

answered Jan 22 '20 at 14:02

Ahmad MOUSSA

2,729
19
31

score 0 · Answer 5 · answered Jul 27 '18 at 07:41

0

If you are looking for a query in mongoid this is the oneModel.where(:field.in => ["value1", "value2"] ).all.to_a

answered Jul 27 '18 at 07:41

Prithviraj Pillai

1
3

score 0 · Answer 6 · answered Jun 24 '19 at 09:47

There is a 'small' difference between where and find_by.

find_by will return just one record if found otherwise it will be nil.

Finds the first record matching the specified conditions. There is no implied ordering so if order matters, you should specify it yourself. If no record is found, returns nil.

  def find_by(*args)
      where(*args).take
    rescue RangeError
      nil
  end

meanwhile where it will return an relation

Returns a new relation, which is the result of filtering the current relation according to the conditions in the arguments.

So, in your situation the appropriate code is:

Model.where(id: [array of values])

ActiveRecord where field = ? array of possible values

6 Answers6

Linked