Updating nested arrays in mongoDB via mongo shell [duplicate]

by

You are directly hitting one of the current limitations of MongoDB.
The problem is that the engine does not support several positional operators.
See this Multiple use of the positional `$` operator to update nested arrays

There is an open ticket for this: https://jira.mongodb.org/browse/SERVER-831 (mentioned also there)

You can also read this one on how to change your data model: Updating nested arrays in mongodb

If it is feasible for you, you can do:

db.collection.update({_id:2,"event_type.name":'MT' ,"event_type.language.name":'English'},{$set:{"event_type.0.language.$.count":<number>}})

db.collection.update({_id:2,"event_type.name":'MT' ,"event_type.language.name":'English'},{$set:{"event_type.$.language.0.count":<number>}})

But you cannot do: 

db.collection.update({_id:2,"event_type.name":'MT' ,"event_type.language.name":'English'},{$set:{"event_type.$.language.$.count":<number>}})

More Related Contents:

  1. $lookup on ObjectId’s in an array
  2. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  3. In mongoDb, how do you remove an array element by its index?
  4. Mongodb update deeply nested subdocument
  5. How do I seed a mongo database using docker-compose?
  6. How to create a DB for MongoDB container on start up?
  7. How to access a preexisting collection with Mongoose?
  8. How do I query for distinct values in Mongoose?
  9. MongoDB field order and document position change after update
  10. MongoDB Full and Partial Text Search
  11. How to enable authentication on MongoDB through Docker?
  12. Mongodb Join on _id field from String to ObjectId
  13. Difference between count() and find().count() in MongoDB
  14. Remove embedded document in a nested array of documents
  15. Find all documents within last n days
  16. Unable to create/open lock file: /data/mongod.lock errno:13 Permission denied
  17. Mongo, find through list of ids
  18. MongoDB: Server has startup warnings ”Access control is not enabled for the database”
  19. Mongo group and push: pushing all fields
  20. How to stop insertion of Duplicate documents in a mongodb collection
  21. Difference between “id” and “_id” fields in MongoDB
  22. Filtering embedded documents in MongoDB
  23. Is mongodb running?
  24. MongoDB via Mongoose JS – What is findByID?
  25. mongo: command not found on mongodb 6.0 docker container [duplicate]
  26. Mongodb: Perform a Date range query from the ObjectId in the mongo shell
  27. MongoDB server can still be accessed without credentials
  28. Mongodb, aggregate query with $lookup
  29. Mongo unique index case insensitive
  30. Cannot create index in mongodb, “key too large to index”

Leave a Comment