Mongoose find returns empty array

Question

I have mongoDB document which looks like this:

{
    "_id": {
        "$oid": "5b99247efb6fc01dae438815"
    },
    "participants": [
        "5b758a8341ee61f049ded486",
        "5b94fb4ffb6fc01dae40eae3"
    ]
}

The document Schema in Mongoose is defined as such

var conversationSchema = new mongoose.Schema({
    participants: [{ type: mongoose.Schema.ObjectId, ref: 'User'}],
});

I am fetching the data as such

var ccc = Conversation.find({participants : "5b758a8341ee61f049ded486"});
ccc.exec(function(err, conversations){
   res.status(200).json(conversations);
});

The problem is that I am getting an empty array response [].

I think the problem is with Schema but I can't figure out how can I make this to work.

EDIT, If I change my Schema to the following it will work:

var conversationSchema = new mongoose.Schema({
    participants: [{ type: String}],
});

But I want to work with mongoose.Schema.ObjectId and not Strings as foreign key.

Cast your participants id with ObjectId... Conversation.find({ participants: ObjectId("5b758a8341ee61f049ded486") }) — Ashh
– Ashh, Commented Sep 14, 2018 at 16:05
Tried this mongoose.Types.ObjectId("5b758a8341ee61f049ded486") but still same empty array response. — user10364602
– user10364602, Commented Sep 14, 2018 at 16:14

vitomadio · Accepted Answer · 2018-09-14 17:19:07Z

2

Try adding Types to this line:

participants: [{ type: mongoose.Schema.Types.ObjectId, ref: 'User'}]

It wont recognize the items in the array because they are strings you should have instead an object like {"$oid": "585bb0086c57cd2265b1cbd3"} so reinsert the items in you db and try again.

edited Sep 14, 2018 at 17:19

answered Sep 14, 2018 at 17:13

vitomadio

1,1308 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Mongoose find returns empty array

I think the problem is with Schema but I can't figure out how can I make this to work.

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

I think the problem is with Schema but I can't figure out how can I make this to work.

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest