update multiple object with $gt operator inside array in mongodb [duplicate]

Question

I am trying to update an array inside document in which i want to perform update operation based on a greater than condition.

Here is my document:

{  
  _id:some_id,
  name:"test",
  data:[
         { __id:1,
           __data:[{a:"something"}]
          },
           { __id:2,
           __data:[{a:"something"}]
          },
           { __id:3,
           __data:[{a:"something"}]
          }....
        ]
}

I want to subtract 1 from __id of every element in the data array if its __id is greater than 2

Currently i am doing this but it is not working

db.collection('collection_name').update({name:"test","data.__id":{$gt:2}},{$inc:{"data.__id":-1}},{multi:true})

Ashh · Accepted Answer · 2019-01-08 16:47:21Z

1

You have to use $ positional operator to update value inside an array

db.getCollection('test').update(
 { "name": "test" , "data.__id": { "$gt": 2 }},
 { "$inc": { "data.$.__id": -1 }},
 { "multi": true }
)

edited Jan 8, 2019 at 16:47

answered Dec 29, 2018 at 10:15

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

5 Comments

Faiz Khan Over a year ago

above query only update single document not all documents matching the condition

Ashh Over a year ago

Updated my answer

Faiz Khan Over a year ago

i tried that before but it wasn't working, and i am also using a callback with this so is that a problem

Ashh Over a year ago

No callback or .then is necessary here. multi:true didn't work?

Faiz Khan Over a year ago

yes take a look at this : collection.update({"name":data.toRoom,"tab_data.__id":{"$gt":parseInt(data.removeWithId)}},{"$inc":{"tab_data.$.__id":-1}},{"multi": true},callback)

Collectives™ on Stack Overflow

update multiple object with $gt operator inside array in mongodb [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related