Mongoose findOne array of ObjectId returns null

Question

Having some issues performing a findOne query with an array of ObjectIds. Simplified schema as follows:

Model:

var InboxSchema = new Schema({
    _users: [
        {
            type: mongoose.Schema.ObjectId,
            ref: 'User',
            required: 'Users are required',
            unique: true
        }
    ]
}

mongoose.model('Inbox', InboxSchema)

Query:

var users = [];
var userIds = ['5567ead844997f969fe3f00f', '558b8492f1723b090b414765'];

for (var i=0; i<userIds.length; i++) {
    users.push(new mongoose.Types.ObjectId(userIds[i]));
}

Inbox.findOne({_users: users}).exec(function (err, inbox) {
    console.log(inbox);
}

Inbox always returns null despite it returning something when using Mongo shell, so I know that my query works. Previously, I was querying on just userIds alone, which I later realised was not working as I would have to query using ObjectId. However, even converting the strings to ObjectId doesn't work.

Blakes Seven · Accepted Answer · 2015-06-28 16:08:22Z

5

Try using the mongo array query operators $all or $in.

$all to match a target to all of the array elements:

Inbox.findOne({ "_users": { "$all": users} }).exec(function (err, inbox) {
    console.log(inbox);
})

$in to match a target to any of the array elements:

Inbox.findOne({ "users": { "$in": users} }).exec(function (err, inbox) {
    console.log(inbox);
})

edited Jun 28, 2015 at 16:08

Blakes Seven

50.5k14 gold badges132 silver badges136 bronze badges

answered Jun 28, 2015 at 15:54

Adam Wysocki

3232 silver badges10 bronze badges

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

6 Comments

JohnnyHK Over a year ago

It's also worth noting that the OP doesn't need to manually cast the strings to ObjectIds as Mongoose will do that for you based on the schema.

Blakes Seven Over a year ago

I wish all :"first posts" were of such quality. Many people can learn from the succint and true points made here. My edits are only to add links that maybe you cannot, and improve the portabilty of JSON syntax. Well done.

mrkre Over a year ago

Solved the issue. Thanks @AdamWysocki for the help.

mrkre Over a year ago

@JohnnyHK: I was wondering about the casting, thanks for the tip.

Blakes Seven Over a year ago

@AdamWysocki Not that chatter is a good thing here either, but see what I just did there with @ and your username. That is how you "tag" here to alert and respond to those who comment. Unless they are watching people don't see your comments otherwise. Best look at the "help center" link. Happy contributing.

|

Collectives™ on Stack Overflow

Mongoose findOne array of ObjectId returns null

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related