Select where not null or empty in mongoid

ruby-on-rails mongoid
methodofaction picture methodofaction · Apr 26, 2012 · Viewed 38.3k times · Source

I modified a model so it includes a new field, such as...

field :url, :type => String

I use activeadmin, so when I create a new entry @model.url is empty, and in entries created before changing the schema it's nil. How do I select both? I have tried:

# Returns nils and strings
Model.where(:url.ne => "").count 

# Returns strings and ""
Model.where(:url.ne => nil).count

# Returns strings, nils and ""
Model.where(:url.ne => ["", nil]).count

Or, if there's a best practice for this kind of scenario please let me know.

Answer

Kyle picture Kyle · Apr 26, 2012

Try

Model.where(:url.ne => "", :url.exists => true).count

see Mongoid Symbol Operators

Related questions

ERROR Original Error: ImageMagick/GraphicsMagick is not installed

I have an app that is using Imagemagick, but I had to rebuild my environment and now when I try and upload an avatar (which is why I am using Imagemagick), it keeps giving me the following error when I …

Read More
How to implement has_many :through relationships with Mongoid and mongodb?

Using this modified example from the Rails guides, how does one model a relational "has_many :through" association using mongoid? The challenge is that mongoid does not support has_many :through as ActiveRecord does. # doctor checking out patient class Physician &…

Read More
Mongoid OR query syntax

This must be asked alot but it is very poorly documented. There is no mention at http://mongoid.org/en/mongoid/docs/querying.html I'm trying to check whether a user exists (below is an AND query), how can I …

Read More