How to populate nested array in Mongoose

Question

I got stuck at populating my array... this is what i get from my Terminal.find() function:

{ _id: 5a7300046f18140d5081be83,
  type: 5a71a22b0d4a2d0ec3b91edc,
  serial: '213',
  macAddress: 'E1:12:BE:82:12',
  barcode: '1243w464563',
  dateArrival: 2018-02-01T11:54:15.870Z,
  firmware: 5a71a2030d4a2d0ec3b91edb,
  installedAt: 5a61e547922c6d28e324d775,
  installedAtBranch: 5a7054713fe20c0c5a94fb11,
  __v: 0,
  deleted: false,
  activated: true }

So i want to get the correct information, when a user searches for the terminal. This is why i have to use populate(). Difficult for me now is to populate things deeper inside the array. So the first Object type has a readMethod, a layout and interfaces - i have to populate those three, but i don't know how. This is aggravated by the fact that interfaces is an Object inside my Database. So my type looks like this:

I think if someone can show me how to populate type with all of its interfaces i can achive the rest on my own.

Thanks in advance!

I found the answer on my own by searching deeper inside google:

Terminal.findOne({'barcode': barcode})
        .populate({ 
            path: 'type',
            populate: [{
                path: 'user',
                model: 'User'
            },
            {
                path: 'method',
                model: 'Method',
            },
            {
                path: 'layout',
                model: 'Layout'
            },
            {
                path: 'interfaces',
                model: 'Interface'
            }]
        })
        .populate('firmware')
        .populate('customerId')
        .populate('branchId')
        .exec( function (err, terminal) {
        if (err) {
            res.status(500).send(err);
        }
        res.json({ terminal });
    });

Ridham Tarpara · Accepted Answer · 2018-02-01 14:47:12Z

1

As you are using mongoose then I think your model should look like following or it must be like following

Terminal Type Schema

var terminalTypeSchema = new Schema({
    articlenumber: { type: Number, default: something },
    readMethod: Schema.ObjectId,
    layout: Schema.ObjectId,
    interfaces: [{ type: Schema.ObjectId, ref: 'User' }]
});
mongoose.model('TerminalType', terminalTypeSchema);

Interface Schema

var interfaceSchema = new Schema({
    // some vars
});
mongoose.model('Interface', interfaceSchema);

Now run following query

TerminalType.findOne({ _id: terminalTypeId})
.populate('interfaces') // <==
.exec(function(err, terminalTypes){
    // You can achieve the rest on your own.
});

answered Feb 1, 2018 at 14:47

Ridham Tarpara

6,1804 gold badges22 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

How to populate nested array in Mongoose

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