ActiveRecord Arel OR condition

by

ActiveRecord queries are ActiveRecord::Relation objects (which maddeningly do not support or), not Arel objects (which do).

[ UPDATE: as of Rails 5, “or” is supported in ActiveRecord::Relation; see https://stackoverflow.com/a/33248299/190135 ]

But luckily, their where method accepts ARel query objects. So if User < ActiveRecord::Base…

users = User.arel_table
query = User.where(users[:kind].eq('admin').or(users[:kind].eq('author')))

query.to_sql now shows the reassuring:

SELECT "users".* FROM "users"  WHERE (("users"."kind" = 'admin' OR "users"."kind" = 'author'))

For clarity, you could extract some temporary partial-query variables:

users = User.arel_table
admin = users[:kind].eq('admin')
author = users[:kind].eq('author')
query = User.where(admin.or(author))

And naturally, once you have the query you can use query.all to execute the actual database call.

More Related Contents:

  1. Rails 4 LIKE query – ActiveRecord adds quotes
  2. Join multiple tables with active records
  3. PostgreSQL where all in array
  4. Find all records which have a count of an association greater than zero
  5. Rails find record with zero has_many records associated [duplicate]
  6. ActiveRecord find_each combined with limit and order
  7. Rails ActiveRecord methods in different places [closed]
  8. Rails raw SQL example
  9. ActiveRecord.find(array_of_ids), preserving order
  10. Using Rails serialize to save hash to database
  11. Rails 3: Get Random Record
  12. Rails 5: ActiveRecord OR query
  13. Multiple CTE in single query
  14. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  15. LEFT OUTER JOIN in Rails 4
  16. Rails 3 execute custom sql query without a model
  17. How to round an average to 2 decimal places in PostgreSQL?
  18. Rails: ActiveRecord query based on association value
  19. Rails 3, has_one / has_many with lambda condition
  20. Rails ActiveRecord: Find All Users Except Current User
  21. query , can not select column count
  22. How to use ActiveRecord in a ruby script outside Rails?
  23. Using helpers in model: how do I include helper dependencies?
  24. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  25. delete_all vs destroy_all?
  26. Converting an array of objects to ActiveRecord::Relation
  27. How to implement bulk insert in Rails 3
  28. Is there a way to avoid automatically updating Rails timestamp fields?
  29. Rails: Overriding ActiveRecord association method
  30. Rails Object Relationships and JSON Rendering

Leave a Comment