Mongoose how to search inside an object nested in an array?

Question

JavaScript

Let's say we have a collection consisting of the following type of objects:

Users = {
    firstName: 'String',
    lastName: 'String,
    otherInfo: [
        {_id: ''},
        {_id: ''},
        {_id: ''}
   ]
}

Is it possible to return objects by the '_id' key or just return all objects and then iterate over them? which I would not like to do for obvious reasons.
Thank you.

Answer 1

stackoverflow.com/questions/10885044/mongodb-how-t...

Answer 2

You can bind the query via .populate:
model:

User = new Schema({
    firstName: 'String',
    lastName: 'String,
    otherInfo: [{type: Schema.ObjectId, ref: 'OtherInfoSchema'} ]
});

запрос:
запрос вернется с развернутой otherInfo:

... 
  lastName: 'String,
    otherInfo: [
        {_id: '0', name: '', ... },
        {_id: '1', name: '', ... }
   ]