How to update deep nested Arrays in MongoDB?

Hi Everyone,

Have been trying to update a nested Array in mongoDB but unsuccesssful , can anyone guide me to get the desired output achieved;

req.body = { 
      orderId: "620bacce71ace5b5525c8283", 
        sellerOrderStatusId: "620bacce71ace5b5525c828d",
        type: "packed"
}

req.body = { 
      orderId: "620bacce71ace5b5525c8283", 
        sellerOrderStatusId: "620bacce71ace5b5525c828d",
        type: "packed"
}

sending above parameters from frontEnd.

exports.updateOrder = (req, res) => {
    Order.updateOne(
        { "_id": req.body.orderId, "sellerOrderStatus.type": req.body.type },
        {
            $set: {
                "sellerOrderStatus.$": [
                    { type: req.body.type, date: new Date(), isCompleted: true },
                ],
            },
        }
    ).exec((error, order) => {
        if (error) return res.status(400).json({ error });
        if (order) {
            res.status(201).json({ order });
        }
    });
};

exports.updateOrder = (req, res) => {
    Order.updateOne(
        { "_id": req.body.orderId, "sellerOrderStatus.type": req.body.type },
        {
            $set: {
                "sellerOrderStatus.$": [
                    { type: req.body.type, date: new Date(), isCompleted: true },
                ],
            },
        }
    ).exec((error, order) => {
        if (error) return res.status(400).json({ error });
        if (order) {
            res.status(201).json({ order });
        }
    });
};

with above req.body and function =>>>>>> below is response

{
    "order": {
        "acknowledged": true,
        "modifiedCount": 1,
        "upsertedId": null,
        "upsertedCount": 0,
        "matchedCount": 1
    }
}

{
    "order": {
        "acknowledged": true,
        "modifiedCount": 1,
        "upsertedId": null,
        "upsertedCount": 0,
        "matchedCount": 1
    }
}

I am getting this success msg as modified content . But still in DB it is unchanged .

screenshot of DB structure is attached for reference .

Hope I get help from here or if anyone facing similar issue.

Thank You

155

Entertainment & Education

New

Master Software Development

Learn trending tech & full-stack development. Book now

View Details

Explore more similar Post

1 Comments

Entertainment & Education

16 February 2022

I have the solution, sorry for the trouble. I have changed the functionality to :::: exports.updateOrder = (req, res) => { Order.update( {}, { $set: { "packedStatusWithDiffSellers.$[x].sellerOrderStatus.$[y]": { type: req.body.type, date: new Date(), isCompleted: true } } }, { arrayFilters: [ { "x.sellerId": { "$eq": req.body.sellerId } }, { "y.type": { "$eq": req.body.type }, "y.isCompleted": { "$eq": "false" } } ], multi: true }).exec((error, order) => { if (error) return res.status(400).json({ error }); if (order) { res.status(201).json({ order }); } }); }; and sent req.body = { sellerId: "6203e4bd60659b37ebeb7569", type: "packed" }