MongoDB updating fields in nested array

by

This issue has been resolved. Feature of updating fields
inside nested array of objects, is available in MongoDB 3.6+ versions.
Look positional operators(all and with identifier) here.

//Update all docs in collection matching photo name "play" to "play photo"
db.collectioname.update(
    {},
    { $set: { "albums.$[].photos.$[photo_field].name": "play photo" } },
    { arrayFilters: [  {"photo_field.name": "play"} ], multi: true}
);

//Update this specific doc given in question matching photo name "play" to "play photo"
db.collectioname.update(
    {"_id" : ObjectId("4f41a5c7c32810e404000000")},
    { $set: { "albums.$[].photos.$[photo_field].name": "play photo" } },
    { arrayFilters: [  {"photo_field.name": "play"} ]}
);

This is for the help of people coming here after MongoDB 3.6

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. Gather column name of a table from database [closed]
  3. I am seeing this error on submitting form Error: query was empty [closed]
  4. Automated or regular backup of mysql data
  5. strange character encoding of stored data , old script is showing them fine new one doesn’t
  6. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  7. How can I store and retrieve images from a MySQL database using PHP?
  8. PDO mysql: How to know if insert was successful
  9. Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL
  10. How to loop through a mysql result set
  11. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  12. Mechanisms for tracking DB schema changes [closed]
  13. How to get the total number of rows of a GROUP BY query?
  14. Fetching single row, single column with PDO
  15. How to connect to mssql using pdo through PHP and Linux?
  16. Is there any way to check the performance of mysql Indexing
  17. Calculate skip value for given record for sorted paging
  18. IP address storing in MySQL database using PHP [duplicate]
  19. Proper Repository Pattern Design in PHP?
  20. Fastest hash for non-cryptographic uses?
  21. retrieve data from db and display it in table in php .. see this code whats wrong with it?
  22. PHP – Secure member-only pages with a login system
  23. Advantages / Disadvantages of pconnect option in CodeIgniter
  24. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  25. Fatal error: Class ‘MongoDB\Driver\Manager’ not found
  26. Laravel Change Connection Dynamically
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. looping a SQL insert statement with dates
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment