Comment by Sandeep Panda on "How to update multiple array elements in MongoDB?"

CommentHow to update multiple array elements in MongoDB?

Sandeep Panda

co-founder, Hashnode

Jan 18, 2017

Can you change the snippet to: .update({_id : ObjectId("587e2be4411f058ab566d7dc")},{$set:{"body.viewed.main":true}},{multi : true}); and see if it works?

Note: I have removed the positional operator ($).

karthik

self-taught programmer, startup enthusiast & engineer

Jan 18, 2017

initially i tried that but mongo throws an error , if i use $ it takes first matched element .

{ MongoError: cannot use the part (body of body.viewed.main) to traverse the element ({body: [ { type: "in", message: "yes", _id: ObjectId('587e2be40456010a3f4e3b8a'), createDate: new Date(1484663780842), hidden: false, viewed: { sub: false, main: false } }, { type: "in", message: "yes", _id: ObjectId('587e2be40456010a3f4e3c8a'), createDate: new Date(1484663780842), hidden: false, viewed: { sub: false, main: false } } ]})

Alok Deshwal

Node.js Developer | AWS guru

Jan 18, 2017

As per mongodb , As of now , there's no way to do this in single click.you'll have to loop through

karthik

self-taught programmer, startup enthusiast & engineer

Jan 19, 2017

@alokdeshwal yes we are looping through it .But its very bad if number of documents & array elements increase :( . It will be order of n times n( O(n*n) ) to update all .

SHOBHIT GUPTA

Feb 16, 2018

It's updated in jira.mongodb.org/browse/SERVER-1243

Search Hashnode