ActiveRecord OR query

Question

How do you do an OR query in Rails 3 ActiveRecord  All the examples I find just have AND queries      Edit  OR method is available since Rails 5  See ActiveRecord  QueryMethods

User · Accepted Answer

Use ARel  t   Post arel table  results   Post where    t  author  eq  Someone      or t  title  matches   something         The resulting SQL   ree-1 8 7-2010 02  gt  puts Post where t  author  eq  Someone   or t  title  matches   something      to sql SELECT      posts    FROM        posts   WHERE        posts   author     Someone  OR  posts   title  LIKE   something

User · Answer

If you want to use an OR operator on one column s value  you can pass an array to  where and ActiveRecord will use IN value other value    Model where  column   gt    value    other value     outputs   SELECT  table name    FROM  table name  WHERE  table name   column  IN   value    other value     This should achieve the equivalent of an OR on a single column

User · Answer

Book where any of Book where  author   gt   Poe    Book where  author   gt   Hemingway

User · Answer

in Rails 3  it should be  Model where  column     or other column       value  other value    This also includes raw sql but I dont think there is a way in ActiveRecord to do OR operation  Your question is not a noob question

User · Answer

I just extracted this plugin from client work that lets you combine scopes with  or   ex  Post published or authored by current user   Squeel  newer implementation of MetaSearch  is also great  but doesn t let you OR scopes  so query logic can get a bit redundant

User · Answer

Just add an OR in the conditions  Model find  all   conditions   gt    column     OR other column      value  other value

User · Answer

With rails   arel  a more clear way     Table name  messages     sender id     integer   recipient id  integer   content       text  class Message  lt  ActiveRecord  Base   scope  by participant  - gt  user id  do     left    arel table  sender id  eq user id      right   arel table  recipient id  eq user id       where Arel  Nodes  Or new left  right     end end   Produces     Message by participant User first id  to sql    gt  SELECT  messages          FROM  messages       WHERE  messages   sender id    1         OR  messages   recipient id    1

User · Answer

An updated version of Rails ActiveRecord may support this syntax natively  It would look similar to   Foo where foo   bar   or where bar   bar     As noted in this pull request https   github com rails rails pull 9052  For now  simply sticking with the following works great   Foo where  foo    OR bar       bar    bar     Update  According to https   github com rails rails pull 16052 the or feature will be available in Rails 5  Update  Feature has been merged to Rails 5 branch

User · Answer

Rails 5 comes with an or method   link to documentation   This method accepts an ActiveRecord  Relation object  eg   User where first name   James   or User where last name   Scott

User · Answer

If you want to use arrays as arguments  the following code works in Rails 4   query   Order where uuid  uuids  id  ids  Order where query where values map  amp  to sql  join   OR        gt  Order Load  0 7ms   SELECT  orders    FROM  orders  WHERE   orders   uuid  IN   5459eed8350e1b472bfee48375034103    21313213jkads    43ujrefdk2384us   OR  orders   id  IN  2  3  4     More information  OR queries with arrays as arguments in Rails 4

User · Answer

I d like to add this is a solution to search multiple attributes of an ActiveRecord  Since    where A  param  A   B  param  B     will search for A and B

User · Answer

The MetaWhere plugin is completely amazing   Easily mix OR s and AND s  join conditions on any association  and even specify OUTER JOIN s   Post where  sharing level  Post  Sharing  everyone       sharing level  Post  Sharing  friends    amp   user   followers  current user     joins  user outer   gt   followers outer

User · Answer

You could do it like   Person where  name     OR age        Pearl   24    or more elegant  install rails or gem and do it like   Person where  name   gt   Pearl   or  age   gt  24

User · Answer

Rails has recently added this into ActiveRecord  It looks to be released in Rails 5  Committed to master already   https   github com rails rails commit 9e42cf019f2417473e7dcbfcb885709fa2709f89  Post where column   something   or Post where other   else         gt  SELECT   FROM posts WHERE  column    something   OR  other    else

[ruby-on-rails] ActiveRecord OR query

Examples related to ruby-on-rails

Examples related to ruby-on-rails-3

Examples related to rails-activerecord