Assume I have this model:
class Conversation < ActiveRecord::Base
enum status: [ :active, :archived ]
end
How can I find all active conversations without using the numeric value of the enum or without having to iterate over each conversation?
I tried doing Conversation.where(status: :active)
, but it didn't yield any results.
The only solution comes to mind is to iterate over all conversations and select the active ones, but it doesn't look like a good solution.
Conversation.all.select {|conversation| conversation.active? }
Is there anything I can do about this?
ActiveRecord::Enum
provides scopes based on its values.
Just try:
Conversation.active
or
Conversation.archived
Of course, you can create your own scopes as Kyle Decot mentioned.
This works great:
Conversation.where("conversation.status = ?", Conversation.statuses[:active])
For some reason this does NOT work:
Conversation.where(status: :active) #searches for NULL Conversation.where(status: 'active') #searches for status=0 no matter what the enum
All the above statements work with Rails 5. Happy coding!
ActiveRecord::Enum provides built-in scopes based on the values so you can simply do:
Conversation.active
Conversation.archived
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With