Rails where condition using NOT NIL

by

Rails 4+

ActiveRecord 4.0 and above adds where.not so you can do this:

Foo.includes(:bar).where.not('bars.id' => nil)
Foo.includes(:bar).where.not(bars: { id: nil })

When working with scopes between tables, I prefer to leverage merge so that I can use existing scopes more easily.

Foo.includes(:bar).merge(Bar.where.not(id: nil))

Also, since includes does not always choose a join strategy, you should use references here as well, otherwise you may end up with invalid SQL.

Foo.includes(:bar)
   .references(:bar)
   .merge(Bar.where.not(id: nil))

Rails 3

The canonical way to do this with Rails 3:

Foo.includes(:bar).where("bars.id IS NOT NULL")

More Related Contents:

  1. Combine two ActiveRecord::Relation objects
  2. Rails extending ActiveRecord::Base
  3. How to change default timezone for Active Record in Rails?
  4. Rails :include vs. :joins
  5. ActiveModel::ForbiddenAttributesError when creating new user
  6. ActiveRecord OR query
  7. Rails 4 scope to find parents with no children
  8. ActiveRecord: size vs count
  9. Rails: How can I set default values in ActiveRecord?
  10. Connecting Rails 3.1 with Multiple Databases
  11. How to express a NOT IN query with ActiveRecord/Rails?
  12. How to do a LIKE query in Arel and Rails?
  13. ActiveRecord OR query Hash notation
  14. How to chain scope queries with OR instead of AND?
  15. Rails 5: ActiveRecord OR query
  16. Clean way to find ActiveRecord objects by id in the order specified
  17. Rails – Nested includes on Active Records?
  18. ActiveRecord Find By Year, Day or Month on a Date field
  19. Rails 3 SQLite3 Boolean false
  20. Float vs Decimal in ActiveRecord
  21. find vs find_by vs where
  22. How to skip ActiveRecord callbacks? [duplicate]
  23. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  24. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  25. Can I write PostgreSQL functions on Ruby on Rails?
  26. New data not persisting to Rails array column on Postgres
  27. Ruby on rails – Reference the same model twice?
  28. How to implement bulk insert in Rails 3
  29. What is the difference between pluck and collect in Rails?
  30. Changing a column type to longer strings in rails

Leave a Comment