How to use OR in ActiveRecord Rails 4.1.1?

Question

I'm used scope where(address: [nil, ''], city: [nil, '']) and I get request

WHERE ((`address`.`address` = '' OR `address`.`address` IS
NULL) AND (`address`.`city` = '' OR `address`.`city` IS
NULL))

I need replace AND to OR. How do I build a query using ActiveRecord?

http://stackoverflow.com/questions/17192829/does-rails-4-have-support-for-or-queries — maicher, May 18 '17 at 09:59

Rokibul Hasan · Answer 1 · 2017-05-18T10:14:26.037

0

You can try this

where("address.address in (?) or address.city in (?)", [nil, ''])

In application

scope :empty_address, -> { where("address.address in (?) or address.city in (?)", [nil, '']) }
Address.empty_address

edited May 18 '17 at 10:14

answered May 18 '17 at 10:08

Rokibul Hasan

score 0 · Answer 2 · answered May 18 '17 at 10:28

You can use Arel gem and form you query like:

ids = [nil,''] Address.where(Address.arel_table[:address].in(ids).or(Address.arel_table[:city].in(ids)))

with Arel-helpers you can make it even shorter: Address.where(Address[:address].in(ids).or(Address[:city].in(ids)))

2 Answers2