Mongoid OR query syntax

ruby-on-rails mongoid
Akshat picture Akshat · Oct 21, 2012 · Viewed 21.1k times · Source

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 change it to an OR type query

Username.where(:username=>@username, :email=>@email)

(Either the email or the username must match).

I have found some pretty complicated ways online including sending a direct javascript (from): http://omarqureshi.net/articles/2010-6-17-using-or-in-mongoid

Surely there must be a simple clear syntax to do this correctly?

Answer

James Lim picture James Lim · Jul 19, 2013

For the sake of others who end up on this page, the updated syntax is now

Username.or({username: @username}, {email: @email})

Please refer to the updated docs or relevant impl.

Related questions

Select where not null or empty in mongoid

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 …

Read More
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