Mongoid 'or' and 'in' - querying multiple arrays

Question

I have a document in Mongo with two array fields:

field   :app_usernames,     type:  Array 
field   :email_addresses,   type:  Array

I'd like to create a function which take an array of usernames and an array of email addresses to search collection. The kicker is that I want it to return documents which have any of the values passed in the arrays:

def find_people(usernames_to_search, emails_to_search)...

So given a document with field values:

app_usernames = ['test1','test2','test3']
email_addresses = ['test1@test.com','test2@test.com']

I want the function to find it when any of those values are searched, via the array parameters. It should return this document in the following cases:

find_people nil,['test1@test.com']
find_people ['test3'],['test1@test.com']
find_people ['oldusername'],['test1@test.com']

The last one seems to be causing me trouble.

Thus far I've tried

.or(:app_usernames.in usernames_to_search, :email_addresses.in emails_to_search)

But to no avail.

score 5 · Accepted Answer · answered Oct 10 '14 at 00:26

The or method is meant to be called with a list of individual conditions so that it can turn this:

x.or(condition1, condition2)

into a MongoDB query like:

$or: [ condition1, condition2 ]

When you say:

.or(:app_usernames.in => usernames_to_search, :email_addresses.in => emails_to_search)

How many arguments are you passing to or? The answer is one. You're actually saying this:

.or({ :app_usernames.in => usernames_to_search, :email_addresses.in => emails_to_search })

You need to add the braces yourself so Ruby doesn't collapse the arguments into one Hash:

.or(
  { :app_usernames.in   => usernames_to_search },
  { :email_addresses.in => emails_to_search    }
)

Or something like this:

args = [ ]
args.push(:app_usernames.in => usernames_to_search) if(usernames_to_search.present?)
args.push(:email_addresses.in => emails_to_search)  if(emails_to_search.present?)
query = query.or(*args) if(args.present?)

Mongoid 'or' and 'in' - querying multiple arrays

1 Answers1