Mongoid OR query syntax

Question

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?

James Lim · Answer 1 · 2018-08-19T04:51:58.783

124

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.

edited Aug 19 '18 at 04:51

answered Jul 19 '13 at 13:43

James Lim

12,915
4
40
65

11

In scopes you still have to use `any_of` otherwise it will throw a syntax error. – aledalgrande Apr 02 '14 at 19:06
1

Link posted doesn't tell anything about `.or` nor `any_of`, please refer [here](https://github.com/mongodb/mongoid/blob/master/lib/mongoid/criteria/queryable/selectable.rb) to see detailed documentation and implementation – silva96 Jun 02 '16 at 12:47
you can also use self.or in scopes (because `or` is a keyword in ruby) – Shiyason Apr 12 '17 at 20:49

score 55 · Accepted Answer · answered Oct 21 '12 at 15:56

55

Yeah, this used to be documented better. Try this:

Username.any_of({:username => @username},
                {:email => @email})

answered Oct 21 '12 at 15:56

Sergio Tulentsev

226,338
43
373
367

score 9 · Answer 3 · answered Apr 28 '17 at 02:15

There is a typo in @miguel-savignano's response. According to Stackoverflow the "edit queue is full", which is why I didn't submit an edit.

Proper syntax:

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

A more concise solution:

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

The Mongo selector will resolve to:

{"$or"=>[{"username"=>@username}, {"email"=>@email}]}

I found this question as I was trying to solve for creating "or" queries.

If you are looking to match a string or any one of an array of elements, then you will need to write a Mongoid query with the Mongo '$in' selector.

For example, you have a specific username and an array of emails. You would like to return all results where at least one of the fields matches either the username or one of the emails within the array.

@username = "jess"
@emails = ["hi@mail.com", "test@mail.com", "foo@mail.com"]
User.or({username: ""}, {email: {'$in': @emails}})

The Mongo selector will resolve to:

{"$or"=>[{"first_name"=>""}, {"email"=>{:$in=>["hi@mail.com", "test@mail.com", "foo@mail.com"]}}]}

If you have Users with 2 of the 3 emails in your database, then the selector will return a count of 2.
If you have a User with the username "jess" and 3 additional Users each with one of the given emails, then the selector will return a count of 4.

score 9 · Answer 4 · answered Aug 22 '17 at 00:50

Also, in Mongoid 5.0, if you still want to use the where method, use the following

Username.where('$or' => [ { username: @username }, { email: @email } ])

this is very useful when you are building a kind of query hash in a dynamic way and you need to keep the where method

score 7 · Answer 5 · edited Sep 16 '19 at 12:03

7

In Mongoid 5.0, this works for me

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

edited Sep 16 '19 at 12:03

uzaif

3,511
2
21
33

answered Sep 14 '16 at 09:36

miguel savignano

1,109
13
9

Mongoid OR query syntax

5 Answers5

Linked