Mongoose query for subdocument containing array of objectId's

Question

I have the following schema:

var groupSchema = mongoose.Schema({
name: {type: String, index: {unique: true, dropDups: true}},
createdBy: String,
availableModules: [Number],
members: [{type: Schema.Types.ObjectId, ref: 'User'}]
});

The "members" field is just a straight up array of ObjectID's from the user table. I need to check for the existence of a given ObjectId (user._id) in the members subdocument collection before I take some other action.

I've tried stuff like:

Group.find({req.body.uid}, {$in: {"members"}}, function(grps){..});

But this doesn't work. I've tried a myriad of other methods but can't seem to get anything working. I'd think this would be easy, but I can't seem to figure it out.

EDIT Further Investigation:

User.findOne({"local.email": req.body.user.email}, function(err, user){
    Group.find({"members": user._id}, function(grps){
        if(grps){ //do something}
    });
});

grps is null no matter what way I do it.. tho in the mongo console it's returning the value when using the ObjectId("..") notation

db.groups.find({members: ObjectId("5371a4763b32c3620728acb5")})

Andrei Beziazychnyi · Accepted Answer · 2014-05-13 19:41:54Z

1

Group.find({members: req.body.uid}, function(err, items){})

answered May 13, 2014 at 19:41

Andrei Beziazychnyi

2,9172 gold badges18 silver badges11 bronze badges

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

3 Comments

shredmill Over a year ago

This was my first attempt - so I'm thinking there might be something else at play here. It's still not working. If I type this query in a mongo console, and use the ObjectId("......") syntax.. it returns.. so it's correct, but my type is not matching up for some reason for the equals or whatever it does internally for mongo.

shredmill Over a year ago

I added my expanded code to the original example - have a look and let me know if I'm missing something stupid

Andrei Beziazychnyi Over a year ago

Callback is invalid, function(err,items), not function(items). First parameter is error, second - returned array.

Collectives™ on Stack Overflow

Mongoose query for subdocument containing array of objectId's

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related