Mongodb update deeply nested subdocument

by

Unfortunately, you can’t use the $ operator more than once per key, so you have to use numeric values for the rest. As in:

db.myCollection.update({
    "id": 1, 
    "forecasts.forecast-id": 123, 
    "forecasts.levels.level": "proven", 
    "forecasts.levels.configs.config": "Custom 1"
  },
  {"$set": {"forecasts.$.levels.0.configs.0": newData}}
)

MongoDB’s support for updating nested arrays is poor. So you’re best off avoiding their use if you need to update the data frequently, and consider using multiple collections instead.

One possibility: make forecasts its own collection, and assuming you have a fixed set of level values, make level an object instead of an array:

{
  _id: 123,
  parentId: 1,
  name: "Forecast 1", 
  levels: {
    proven: { 
      configs: [
        { 
          config: "Custom 1",
          variables: [{ x: 1, y:2, z:3}]
        }, 
        { 
          config: "Custom 2",
          variables: [{ x: 10, y:20, z:30}]
        }, 
      ]
    },
    likely: {
      configs: [
        { 
          config: "Custom 1",
          variables: [{ x: 1, y:2, z:3}]
        }, 
        { 
          config: "Custom 2",
          variables: [{ x: 10, y:20, z:30}]
        }, 
      ]
    }
  }
}

Then you can update it using:

db.myCollection.update({
    _id: 123,
    'levels.proven.configs.config': 'Custom 1'
  },
  { $set: { 'levels.proven.configs.$': newData }}
)

More Related Contents:

  1. MongoDB first time user setup [closed]
  2. How do I perform the SQL Join equivalent in MongoDB?
  3. How to remove array element in mongodb?
  4. MongoDB: How to update multiple documents with a single command?
  5. Can you specify a key for $addToSet in Mongo?
  6. How to execute mongo commands through shell scripts?
  7. How do I seed a mongo database using docker-compose?
  8. How do you use Mongoose without defining a schema?
  9. MongoDB: Unique index on array element’s property
  10. Select Max() with “group by” in mongodb
  11. How to print out more than 20 items (documents) in MongoDB’s shell?
  12. How to get back the Original document back after aggregation
  13. Updating the path ‘x’ would create a conflict at ‘x’
  14. MongoDB update with condition
  15. mongodb get distinct records
  16. Get the latest record from mongodb collection
  17. How can I sort into that nulls are last ordered in mongodb?
  18. What does it mean to fit “working set” into RAM for MongoDB?
  19. Mongoose limit/offset and count query
  20. $skip and $limit in aggregation framework
  21. Multiply field by value in Mongodb
  22. Mongodb Aggregation Framework | Group over multiple values?
  23. Group by sum mongodb [duplicate]
  24. How to check if an array field contains a unique value or another array in MongoDB?
  25. MongoDB.service failed with result exit-code
  26. How can I sort a Meteor collection by time of insertion?
  27. MongoDB index/RAM relationship
  28. Export mongodb aggregation framework result to a new collection
  29. MongoDB aggregate by field exists
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment