Mongo Array in Array Query

Question

Given the below example record, how can I find all users that belong to at least one group from an arbitrary set of groups to query against? For example, find all users that belong to any one of the following groups - 1, 10, 43. I'm looking for a generalized solution. I know I can build out an or query but is there a more efficient way to handle this?

> db.users.findOne()
{
    "_id" : ObjectId("508f477aca442be537000000"),
    "name" : "Some Name",
    "email" : "[email protected]",
    "groups" : [
        1,5,10
    ]
}

Whats the problem with $or query.. its a perfect way to do it.. — RameshVel
– RameshVel, Commented Nov 6, 2012 at 5:16
There's nothing wrong with it. It just requires a loop to build the query whereas I can just drop in my array in the method outlined in the answer below without any additional work. In any case, thanks for your help! — VinnyD
– VinnyD, Commented Nov 6, 2012 at 7:39

Dmitri · Accepted Answer · 2012-11-06 05:15:35Z

3

{ groups: {$in: [1, 10, 43]} }

answered Nov 6, 2012 at 5:15

Dmitri

9,1675 gold badges39 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongo Array in Array Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related