Using ActiveRecord Enum in array selections

Question

I have a model

class Order < ActiveRecord::Base 
  ...
  enum status: [:started, :finished, :failed, :processing]
  ...
end

And want to select all processing and finished orders. I cannot write simply

@orders = Order.where(status:  [:finished, :processing])

because status field is naturally an integer, not string or literal. So this statement generates

2.2.0 :008 > Order.where(status: [:finished, :processing])
   SELECT "orders".* FROM "orders" WHERE "orders"."status" IN (NULL, NULL)

Now i do the following

@orders = Order.where(status:  [:finished, :processing].map { |s| Order.statuses[s] }

Is there any better way?

Thank you, but it breaks abstractions. I want to call order statuses by it's names, not integers — mbeloshitsky
– mbeloshitsky, Commented Jun 1, 2016 at 5:54

Pavan · Accepted Answer · 2016-06-01 06:00:25Z

2

As you want to call order statuses by it's names, the below should work

@orders = Order.where(status: Order.statuses[:finished, :processing])

answered Jun 1, 2016 at 6:00

Pavan

33.6k8 gold badges53 silver badges78 bronze badges

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

1 Answer 1