Write activerecord query in rails

Question

I am having "Order" model with pickup_date, delivery_date and status. So i want to select orders -

if status if picked_up then pickup_date should be some date value (eg, '12/12/2012')
if status if delivered then delivery_date should be some date value (eg, '12/12/2012')

I think we can use WHEN CASE with Activerecord. Can anybody help me in this?

M. Stavnycha · Accepted Answer · 2017-03-06 14:35:08Z

1

Order.where("(status = 'pickup_up' AND pickup_date = :date) OR (status = 'delivered' AND delivery_date = :date)", date: Date.today)

In Rails 5 you can actually already use 'or' method for ActiveRecord relations:

Order.where(status: :picked_up, pickup_date: Date.today).or(Order.where(status: :delivered, delivery_date: Date.today))

answered Mar 6, 2017 at 14:35

M. Stavnycha

4333 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jedi · Accepted Answer · 2017-03-06 15:23:26Z

0

In addition to @M. Stavnycha answer, Rails has a great section on ActiveRecord query interface available here http://guides.rubyonrails.org/active_record_querying.html

answered Mar 6, 2017 at 15:23

jedi

2,2236 gold badges35 silver badges76 bronze badges

Raaj Baskaran · Accepted Answer · 2017-03-06 15:40:21Z

0

Order.where(status: :picked_up).update(:pickup_date '12/12/2012')

Order.where(status: :delivered).update(:delivery_date '12/12/2012')

answered Mar 6, 2017 at 15:40

Raaj Baskaran

958 bronze badges