How to chain scope queries with OR instead of AND?

ruby-on-rails ruby-on-rails-3 activerecord rails-activerecord
user410715 picture user410715 · Sep 10, 2010 · Viewed 111k times · Source

I'm using Rails3, ActiveRecord

Just wondering how can I chain the scopes with OR statements rather than AND.

e.g. 

Person.where(:name => "John").where(:lastname => "Smith")

That normally returns:

name = 'John' AND lastname = 'Smith'

but I'd like: 

`name = 'John' OR lastname = 'Smith'

Answer

Petros picture Petros · Sep 10, 2010

You would do

Person.where('name=? OR lastname=?', 'John', 'Smith')

Right now, there isn't any other OR support by the new AR3 syntax (that is without using some 3rd party gem).

Related questions

Validate uniqueness of multiple columns

Is there a rails-way way to validate that an actual record is unique and not just a column? For example, a friendship model / table should not be able to have multiple identical records like: user_id: 10 | friend_id: 20 user_id: 10 | …

Read More
Rails: validate uniqueness of two columns (together)

I have a Release model with medium and country columns (among others). There should not be releases that share identical medium/country combinations. How would I write this as a rails validation?

Read More
ActiveRecord Find By Year, Day or Month on a Date field

I have an ActiveRecord model that has a date attribute. Is it possible to utilize that date attribute to find by Year, Day and Month: Model.find_by_year(2012) Model.find_by_month(12) Model.find_by_day(1) or is it …

Read More