How to find and update an array in the object of array document using mongoose

Question

A query to how to update the items array of object by

finding the breed dachshund
update the name to new-dog
updatedAt to the current time

[{
    "_id" : ObjectId("60053b74aa72f132cb75b8b6"),
    "clientId" : "test",
    "items" : [ 
        {
            "_id" : ObjectId("60053b74aa72f132cb75b8b7"),
            "name" : "tommy",
            "breed" : "dachshund",
            "createdAt" : 1610955636,
            "updatedAt" : 1610955636
        }, 
        {
            "_id" : ObjectId("60053b74aa72f132cb75b8b8"),
            "name" : "mickey",
            "breed" : "husky",
            "createdAt" : 1610955636,
            "updatedAt" : 1610955636
        }, 
        {
            "_id" : ObjectId("60053b74aa72f132cb75b8b9"),
            "name" : "whiskey",
            "breed" : "dachshund",
            "createdAt" : 1610955636,
            "updatedAt" : 1610955636
        }, 
        {
            "_id" : ObjectId("60053b74aa72f132cb75b8ba"),
            "name" : "milo",
            "breed" : "bulldog",
            "createdAt" : 1610955636,
            "updatedAt" : 1610955636
        }, 
        {
            "_id" : ObjectId("60053b74aa72f132cb75b8bb"),
            "name" : "pooh",
            "breed" : "poodle",
            "createdAt" : 1610955636,
            "updatedAt" : 1610955636
        }
    ],
    "shopname" : "myshopify"
}]

Could you please show your try, you can use update command with arrayFilters. — turivishal
– turivishal, Commented May 13, 2021 at 18:44
model.updateOne({_id: ObjectId("60053b74aa72f132cb75b8b6")}, {arrayFilters: [{'el.breed': 'dachshund'}]},{$set: {'items.name': 'new-dog'}}) — Jai
– Jai, Commented May 13, 2021 at 18:46
You query is not valid, you can read documentation, see similar Update nested array objects based on a property in MongoDB this might help you. — turivishal
– turivishal, Commented May 13, 2021 at 18:56

Jai · Accepted Answer · 2021-05-13 19:08:10Z

0

const curDatetime = moment(moment();

model.updateOne(
{_id: ObjectId("60053b74aa72f132cb75b8b6")}, 
{
   arrayFilters: [
     {'el.breed': 'dachshund'}
   ]
},
{
   $set: {
     'items.$[el].name': 'new-dog',
     'items.$[el].updatedAt': curDatetime
   }
}, "multi": true)

answered May 13, 2021 at 19:08

Jai

617 bronze badges

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

Collectives™ on Stack Overflow

How to find and update an array in the object of array document using mongoose

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related