How to express a NOT IN query with ActiveRecord/Rails?

by

Rails 4+:

Article.where.not(title: ['Rails 3', 'Rails 5'])

Rails 3:

Topic.where('id NOT IN (?)', Array.wrap(actions))

Where actions is an array with: [1,2,3,4,5]

More Related Contents:

  1. Rails extending ActiveRecord::Base
  2. How to change default timezone for Active Record in Rails?
  3. Rails :include vs. :joins
  4. ActiveModel::ForbiddenAttributesError when creating new user
  5. Rails ActiveRecord date between
  6. ActiveRecord OR query
  7. Rails 4 scope to find parents with no children
  8. Random record in ActiveRecord
  9. What is the easiest way to duplicate an activerecord record?
  10. ActiveRecord: size vs count
  11. Connecting Rails 3.1 with Multiple Databases
  12. ActiveRecord OR query Hash notation
  13. How to chain scope queries with OR instead of AND?
  14. Combine two ActiveRecord::Relation objects
  15. Rails 5: ActiveRecord OR query
  16. Rails where condition using NOT NIL
  17. Clean way to find ActiveRecord objects by id in the order specified
  18. Rails – Nested includes on Active Records?
  19. ActiveRecord Find By Year, Day or Month on a Date field
  20. Rails 3 SQLite3 Boolean false
  21. Add a reference column migration in Rails 4
  22. Float vs Decimal in ActiveRecord
  23. find vs find_by vs where
  24. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  25. query , can not select column count
  26. Can I write PostgreSQL functions on Ruby on Rails?
  27. New data not persisting to Rails array column on Postgres
  28. Validate uniqueness of multiple columns
  29. What is the difference between pluck and collect in Rails?
  30. Changing a column type to longer strings in rails

Leave a Comment