Mongoose find in array of objects

Question

I have a Mongoose schema

var MessageSchema = new Schema({
    streamer: {
        streamer_username: String,
        streams: [{
            id: String,
            messages: [{
                date: String,
                username: String,
                message: String,
                song: String
            }]
        }]
    }
})

It contains an array "streams", which contains objects that have the "id" value, as you can see. I'm trying to search the DB with this query.

MsgSchema.find({ "streamer.streamer_username" : streamer_name, "streamer.streams": { "$in": {id: response.data[0].id} }}, (err, found) =>{}})

But i find nothing. Even if i remove the first "username" part, it still doesn't find anything and returns an empty array, so the problem is clearly the second part. What is wrong with my query? I can't find anything about it in the documentation.

Read the docs docs.mongodb.com/manual/tutorial/query-array-of-documents — chridam
– chridam, Commented Oct 24, 2018 at 7:50
MsgSchema.find({ "streamer.streamer_username" : streamer_name, "streamer.streams.id": {"$in": response.data[0].id}}, (err, found) =>{}}) Worked. Thank you. — almarc
– almarc, Commented Oct 24, 2018 at 7:58

Frederiko Ribeiro · Accepted Answer · 2020-07-23 11:44:26Z

4

I am late but I hope it helps other people

You can simply use .find() and inside it, you can create the specifications of the conditions on more than one field nested in an array of documents. The easiest way is:

MessageSchema.find({ "streamer.streams": { id: "XXX" } });

answered Jul 23, 2020 at 11:44

Frederiko Ribeiro

2,4081 gold badge26 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Mongoose find in array of objects

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