find a object via array object value mongodb [duplicate]

Question

So I have a collection:

{
 _id: 1,
 array: [{id:1,something: "anything"}]
},
{
 _id: 2,
 array: [{id:2,something: "anything"}]
}

I want to find the object that has a array that includes the object with the id 1, how do I do that with mongodb's .findOne()?

Code Tech · Accepted Answer · 2021-02-27 07:07:44Z

0

You can find using $elemMatch.

db.collection_name.findOne( { array : { $elemMatch : { id : 1 } } } )

This is another way you can also find using this simple query db.collection_name.findOne( { "array.id" : 1 } )

answered Feb 27, 2021 at 7:07

Code Tech

164 bronze badges

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

1 Answer 1