Rails 5: ActiveRecord OR query

by

The ability to chain or clause along with where clause in ActiveRecord query will be available in Rails 5. See the related discussion and the pull request.

So, you will be able to do the following things in Rails 5:

To get a post with id 1 or 2:

Post.where('id = 1').or(Post.where('id = 2'))

Some other examples:

(A && B) || C:

    Post.where(a).where(b).or(Post.where(c))

(A || B) && C:

    Post.where(a).or(Post.where(b)).where(c)

More Related Contents:

  1. ActiveRecord OR query Hash notation
  2. query , can not select column count
  3. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  4. Rails ActiveRecord methods in different places [closed]
  5. What is the easiest way to duplicate an activerecord record?
  6. How can I avoid running ActiveRecord callbacks?
  7. Rails 4: List of available datatypes
  8. ActiveRecord.find(array_of_ids), preserving order
  9. Rails model without database
  10. Using Rails serialize to save hash to database
  11. Rails 3: Get Random Record
  12. Rails: Access to current_user from within a model in Ruby on Rails
  13. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  14. Clean way to find ActiveRecord objects by id in the order specified
  15. rescue_from ActionController::RoutingError in Rails 4
  16. Rails: ActiveRecord query based on association value
  17. Rails 3, has_one / has_many with lambda condition
  18. Rails update_attributes without save?
  19. Rails ActiveRecord: Find All Users Except Current User
  20. How to use ActiveRecord in a ruby script outside Rails?
  21. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  22. Can I write PostgreSQL functions on Ruby on Rails?
  23. Validate uniqueness of multiple columns
  24. Using helpers in model: how do I include helper dependencies?
  25. delete_all vs destroy_all?
  26. Converting an array of objects to ActiveRecord::Relation
  27. Controller spec unknown keyword: id
  28. Store the day of the week and time?
  29. What is the difference between pluck and collect in Rails?
  30. Rails: Overriding ActiveRecord association method

Leave a Comment