How to remove object from an Array which is under an object Mongodb

Question

I have a data set like this:

{
    "_id" : ObjectId("5bacc98431481e0520856df8"),
    "action" : {
        "count" : 0,
        "shop" : [ 
            {
                "uid" : ObjectId("5c0b396a50b8a627c4172a2b"),

            }, 
            {
                "uid" : ObjectId("5c0b3b471ed11f2124e1e3a8"),

            },
            {
                "uid" : ObjectId("5c0b3b471ed11f2124e1e3a9"),

            }
         ]
      }
}

How will I remove the above object whose uid is ObjectId("5c0b3b471ed11f2124e1e3a8") through mongodb Query?

I used with the approach which is not perfect according to me. My approach is like this:

db.CollectionName.find({_id: ObjectId("5bacc98431481e0520856df8")})
.then(data => {
  if (data.length > 0) {
        let xData = data[0].notifications.shop;
        let xuid = ObjectId("5c0b3b471ed11f2124e1e3a8");
        let filterData = xData.filter(
          x => x.uid!= xuid
        );
        User.update(
          { _id: ObjectId("5bacc98431481e0520856df8")},
          {
            $set: {
              action: { shop: filterData }
            }
          }
        )
        .then(usr => {
          console.log("deleted successfully")
         })
         .catch(er => {
           console.log(er)
         })
  }
})
.catch(error => {
    console.log(error)
})

By this approach I remove the uid from an array which itself under an object. If anyone knows this type of task done through MongoDB Query then please let me know.

Any Help/Suggestion is really appreciated. Thanks in advance for the developer who attempted my Query.

Try this db.collection.findOneAndUpdate( { "_id": ObjectId('5bacc98431481e0520856df8') }, { "$pull": { "action.$.shop": { "uid": ObjectId('5c0b3b471ed11f2124e1e3a8') }}} ) — Ashh
– Ashh, Commented Dec 8, 2018 at 5:24
dear @AnthonyWinzlet i followed your query and get the error that is MongoError: The positional operator did not find the match needed from the query — Ankit
– Ankit, Commented Dec 8, 2018 at 5:30

Akrion · Accepted Answer · 2018-12-08 05:01:02Z

1

The mongo statement to do this would be:

db.getCollection('YOURCOLECTION').update(
{'_id': ObjectId("5bacc98431481e0520856df8")}, 
{ "$pull": 
       { "action.shop": { "uid": ObjectId("5c0b3b471ed11f2124e1e3a8") }} 
})

You would be using $pull command in combination with the $update.

answered Dec 8, 2018 at 5:01

Akrion

18.6k1 gold badge38 silver badges58 bronze badges

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

5 Comments

Ankit Over a year ago

Dear, I follow your query, according to this nothing is pulled on an array. i got the mongodb response that is : { n: 1, nModified: 0, opTime: { ts: Timestamp { bsontype: 'Timestamp', low: 2, high_: 1544246568 }, t: 374 }, electionId: 7fffffff0000000000000176, ok: 1, operationTime: Timestamp { bsontype: 'Timestamp', low: 2, high_: 1544246568 }, '$clusterTime': { clusterTime: Timestamp { bsontype: 'Timestamp', low: 2, high_: 1544246568 }, signature: { hash: [Object], keyId: 0 } } }

Ankit Over a year ago

here nModified is 0 not 1

Akrion Over a year ago

I tested it locally with your exact data on mongoDB 3.6 so I am pretty sure that the query is solid.

Akrion Over a year ago

Make sure you have the correct collection in db.getCollection('YOURCOLECTION') etc

Ankit Over a year ago

Yes You are right, actually I have done a mistypo error, thats the reason, anyways thanks and I accepted the answer

Collectives™ on Stack Overflow

How to remove object from an Array which is under an object Mongodb

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related