Rails 5: ActiveRecord OR query

ruby-on-rails ruby activerecord ruby-on-rails-5 rails-activerecord
K M Rakibul Islam picture K M Rakibul Islam · Sep 24, 2015 · Viewed 43.8k times · Source

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

Answer

K M Rakibul Islam picture K M Rakibul Islam · Sep 24, 2015

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)

Related questions

Change the default value for table column with migration

I try to change the default column value from false to true. But when I run rake db:migrate VERSION=904984092840298 I got the following ERROR. StandardError: An error has occurred, this and all later migrations canceled: PG::InvalidTextRepresentation: ERROR: invalid …

Read More
How to create ActiveRecord tableless Model in Rails 5?

I tried create new model which has auto type casting without table in database. I've tried to inherit from ActiveRecord::Base it's thrown exception ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "people" does not exist Class implementation: class Person < ActiveRecord::…

Read More
How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More