How to update a field of an object in array of array in MongoDB?

Question

My mongodb data is like this,a little complicated because of array in array.

{
"_id" : ObjectId("5e36950f65fae21293937594"),
"userId" : "5e33ee0b4a3895a6d246f3ee",
"notes" : [ 
    {
        "noteId" : ObjectId("5e36953665fae212939375a0"),
        "time" : ISODate("2020-02-02T17:24:06.460Z"),
        "memoryLine" : [ 
            {
                "_id" : ObjectId("5e36953665fae212939375ab"),
                "memoryTime" : ISODate("2020-02-03T17:54:06.460Z"),
                "hasReviewed": false
            }, 
            {
                "_id" : ObjectId("5e36953665fae212939375aa"),
                "memoryTime" : ISODate("2020-02-03T05:24:06.460Z"),
                "hasReviewed": false
            }
        ]
    }
]}

I want to update hasReviewed in memoryLine with _id.For example, i want to update _id:ObjectId(5e36953665fae212939375ab) item's hasReviewed to true . As expected like below :

{
"_id" : ObjectId("5e36950f65fae21293937594"),
"userId" : "5e33ee0b4a3895a6d246f3ee",
"notes" : [ 
    {
        "noteId" : ObjectId("5e36953665fae212939375a0"),
        "time" : ISODate("2020-02-02T17:24:06.460Z"),
        "memoryLine" : [ 
            {
                "_id" : ObjectId("5e36953665fae212939375ab"),
                "memoryTime" : ISODate("2020-02-03T17:54:06.460Z"),
                "hasReviewed": true    <============here updated to true
            }, 
            {
                "_id" : ObjectId("5e36953665fae212939375aa"),
                "memoryTime" : ISODate("2020-02-03T05:24:06.460Z"),
                "hasReviewed": false
            }
        ]
    }
]}

How to deal with it?Thank you.

We can update using $pull function, firstly we can pull node after add push node — Mahesh Bhatnagar
– Mahesh Bhatnagar, Commented Feb 6, 2020 at 4:09

whoami - fakeFaceTrueSoul · Accepted Answer · 2020-02-06 04:19:39Z

1

You can use arrayFilters in .updateOne() to do this :

db.collection.update({ 'notes.memoryLine._id': ObjectId("5e36953665fae212939375ab") },
    { $set: { "notes.$[].memoryLine.$[element].hasReviewed": true } },
    { arrayFilters: [{ "element._id": ObjectId("5e36953665fae212939375ab") }] })

Note : Since memoryLine is an array inside an object of notes array then this notes.$[] would update all objects memoryLine.hasReviewed to true when criteria is matched, in other case if you wanted to update just first matched object you can use notes.$. Also instead of .updateOne() you can use .updateMany() to update multiple documents.

answered Feb 6, 2020 at 4:19

whoami - fakeFaceTrueSoul

18.1k6 gold badges35 silver badges51 bronze badges

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

Comments

JackieWillen · Accepted Answer · 2020-02-06 04:38:55Z

0

I find a solution for this.

db.notes.updateOne({
    userId:"5e33ee0b4a3895a6d246f3ee",
    'notes.0.memoryLine._id': ObjectId("5e36953665fae212939375ab"),
}, {
    '$set': {
        'notes.0.memoryLine.$.hasReviewed': true
    }
});

answered Feb 6, 2020 at 4:38

JackieWillen

7492 gold badges13 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to update a field of an object in array of array in MongoDB?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related