Rails 5: ActiveRecord OR query

Question

How do you do an or query in Rails 5 ActiveRecord? Also, is it possible to chain or with where in ActiveRecord queries?

Answer 1

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) 

Answer 2

We don't need to wait for rails 5 to use this OR query. We can also used it with rails 4.2.3. There is a backport here.

Thank to Eric-Guo for gem where-or, Now we can add this OR functionality in >= rails 4.2.3 also using this gem.