How to exclude an array of ids from query in Rails (using ActiveRecord)?

activerecord ruby-on-rails-3 arel active-relation
CuriousYogurt picture CuriousYogurt · Jan 3, 2011 · Viewed 21.5k times · Source

I would like to perform an ActiveRecord query that returns all records except those records that have certain ids. The ids I would like excluded are stored in an array. So:

ids_to_exclude = [1,2,3]
array_without_excluded_ids = Item. ???

I'm not sure how to complete the second line.

Background: What I've already tried:

I'm not sure background is necessary, but I've already tried various combinations of .find and .where. For example:

array_without_excluded_ids = Item.find(:all, :conditions => { "id not IN (?)", ids_to_exclude })
array_without_excluded_ids = Item.where( "items.id not IN ?", ids_to_exclude)

These fail. This tip might be on the right track, but I have not succeeded in adapting it. Any help would be greatly appreciated.

Answer

nslocum picture nslocum · Nov 14, 2013

Rails 4 solution:

ids_to_exclude = [1,2,3]
array_without_excluded_ids = Item.where.not(id: ids_to_exclude)

Related questions

How do you scope ActiveRecord associations in Rails 3?

I have a Rails 3 project. With Rails 3 came Arel and the ability to reuse one scope to build another. I am wondering if there is a way to use scopes when defining a relationship (e.g. a "has_many"). I …

Read More
Is it possible to get the ActiveRecord::Relation object for an association

Do association methods, such as those defined by has_many and belongs_to utilize ActiveRecord::Relation? If so, is it possible to get the ActiveRecord::Relation object that is being used. We're all aware that Rails 3 is heavily using ActiveRecord::…

Read More
How to implement bulk insert in Rails 3

I need to insert a array of emails as different records into my contacts table. How can this be done. Eg: @email = ["[email protected]", "[email protected]", "[email protected]", ... ] I dont want to use. @email.each do |email| @…

Read More