how to populate nested array ref? mongoose

Question

I found this post which is quite close to my need but somehow I still can't get it to work though

It's a bit hard to explain what kind of nested ref I am talking about. I just start with the code

I have a Products Schema

const ProductSchema = new Schema(Object.assign({
    name: {type: String};
});

an order schema

const OrderSchema = new Schema(Object.assign({
    products: [ {
        product: { type: Schema.Types.ObjectId, ref: 'Products' },
        amount: { type: Number },
        total: { type: Number },
    } ],
});

I tried doing

    const order = await Orders.findOne({
        _id: 'orderId39843984203'
    }).populate({
        path: 'products',
        populate: {
            path: 'product'
        }
    });

I tried something like that, and few other ways such as path: products.product or path: products.product._id and something simliar

but all I can get is the _id, it doesn't populate the whole thing.

Can someone please give me a hand or advice how this would work?

Thanks in advance

EDIT: this is how the document looks like in db for orderSchema

{
    "_id": {
        "$oid": "5ba2e2af52f2ff3f4226015c"
    },
    "products": [
        {
            "_id": {
                "$oid": "5ba2e2ac52f22f3f4226015e"
            },
            "amount": 4,
            "total": 2940
        },
        {
            "_id": {
                "$oid": "5ba2e2ac52f2ff3f5226015d"
            },
            "amount": 1,
            "total": 840
        }
    ],
    "createdAt": {
        "$date": "2018-09-19T23:58:36.339Z"
    },
    "updatedAt": {
        "$date": "2018-09-19T23:58:36.505Z"
    },
    "__v": 0
}

Wai Ha Lee · Accepted Answer · 2019-05-01 08:18:49Z

1

.populate({ path: 'nested', populate: { path: 'deepNested' }});

where nested is first level ref and deepnested is ref of first level of ref.

edited May 1, 2019 at 8:18

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered May 1, 2019 at 8:01

Shalu Saraswat

112 bronze badges

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

Comments

Akrion · Accepted Answer · 2018-09-20 01:08:45Z

0

You should be able to do it with this:

const order = await Orders.findOne({
    _id: 'orderId39843984203'
}).populate('products.product')
.exec((error, doc) => doc);

As per the docs for populate

edited Sep 20, 2018 at 1:08

answered Sep 20, 2018 at 0:59

Akrion

18.6k1 gold badge38 silver badges58 bronze badges

2 Comments

Tsuna Over a year ago

still no luck, I believe I also tried that before but anyways I tried it again but ya, no luck

Tsuna Over a year ago

I edited my post, showing how does the document looks like. Donno why I do feel something is off

Collectives™ on Stack Overflow

how to populate nested array ref? mongoose

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related