How to update nested array document in mongodb

Question

I have a collection looks like

{
 "Aid":12234,
 "items":{
   "itemId":"SP897474",
   "Blocks":[
     {
        "blockId":"W23456",
        "name":"B1",
        "innerBlock":[
           {
              "id":"S23490",
              "name":"IB1",
              "state":true
           },
           {
              "id":"S23491",
              "name":"IB2",
              "state":true
           },
           {
              "id":"S23492",
              "name":"IB3",
              "state":true
           }
        ],
        "active":true
     },
     {
        "blockId":"W23457",
        "name":"B2",
        "innerBlock":[
           {
              "id":"S23482",
              "name":"IB1",
              "state":true
           },
           {
              "id":"S23483",
              "name":"IB2",
              "state":true
           }
        ],
        "active":false
      }
   ]
 },
 "active":true
}

I'm not able to update fields that is of innerBlock array, specially name, status because of nesting. Basically, I wanted to update mentioned fields .Iam already try this query

User.update({
  "items.Blocks.innerBlock.id": req.body.id,
  "Aid": req.body.Aid
}, {
  "$set": {
    "items.Blocks.$.InnerBlock.$.name": req.body.name
  }
})

It shows an error given below

"errmsg": "Too many positional (i.e. '$') elements found in path 'items.Blocks.$.InnerBlock.$.name'"

I'm not sure how to fix it.What can be the query in mongo shell? Thanks.

Yeah I tried it .It shows an error like this "errmsg": "cannot use the part (innerBlock of "items.Blocks.innerBlock.name) to traverse the element — Rajesh Goriga
– Rajesh Goriga, Commented Jan 20, 2017 at 10:15
check this answer out, I think it can help update nester array with mongoose — JSEvgeny
– JSEvgeny, Commented Jan 20, 2017 at 10:36
Try this "items.Blocks[0].InnerBlock[0].name": req.body.name — Saurabh Sharma
– Saurabh Sharma, Commented Jan 21, 2017 at 13:08
I found a solutions here jasonmciver.com/mongo-query-deep-array — Rajesh Goriga
– Rajesh Goriga, Commented Jan 23, 2017 at 10:37

Community · Accepted Answer · 2017-05-23 10:29:32Z

0

Only one positional operator available right now with mongoDB. There are opened feature request for that https://jira.mongodb.org/browse/SERVER-831

check the answer https://stackoverflow.com/a/14855633/2066271

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Jan 20, 2017 at 10:37

vmkcom

1,67812 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to update nested array document in mongodb

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