update multiple object with $gt operator inside array in mongodb

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-08T16:47:21.797

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 08 '19 at 16:47

answered Dec 29 '18 at 10:15

Ashh

44,693
14
105
132

above query only update single document not all documents matching the condition – Faiz Khan Jan 08 '19 at 10:33
Updated my answer – Ashh Jan 08 '19 at 16:47
i tried that before but it wasn't working, and i am also using a callback with this so is that a problem – Faiz Khan Jan 09 '19 at 04:59
No callback or .then is necessary here. `multi:true` didn't work? – Ashh Jan 09 '19 at 05:01
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) – Faiz Khan Jan 09 '19 at 05:48

update multiple object with $gt operator inside array in mongodb

1 Answers1