MongoDB rename database field within array

by

For what it’s worth, while it sounds awful to have to do, the solution is actually pretty easy. This of course depends on how many records you have. But here’s my example:

db.Setting.find({ 'Value.Tiers.0.AssetsUnderManagement': { $exists: 1 } }).snapshot().forEach(function(item)
{    
    for(i = 0; i != item.Value.Tiers.length; ++i)
    {
        item.Value.Tiers[i].Aum = item.Value.Tiers[i].AssetsUnderManagement;
        delete item.Value.Tiers[i].AssetsUnderManagement;
    }
    
    db.Setting.update({_id: item._id}, item);
});

I iterate over my collection where the array is found and the “wrong” name is found. I then iterate over the sub collection, set the new value, delete the old, and update the whole document. It was relatively painless. Granted I only have a few tens of thousands of rows to search through, of which only a few dozen meet the criteria.

Still, I hope this answer helps someone!

Edit: Added snapshot() to the query. See why in the comments.

You must apply snapshot() to the cursor before retrieving any documents from the database.
You can only use snapshot() with unsharded collections.

From MongoDB 3.4, snapshot() function was removed. So if using Mongo 3.4+ ,the example above should remove snapshot() function.

More Related Contents:

  1. How to Update Multiple Array Elements in mongodb
  2. Add new element to existing JSON array with jq
  3. MongoDB: How do I update a single subelement in an array, referenced by the index within the array?
  4. How do you put an image file in a json object?
  5. Post an Array of Objects via JSON to ASP.Net MVC3
  6. Accessing a JSON object in Bash – associative array / list / another model
  7. Swift JSONDecode decoding arrays fails if single element decoding fails
  8. Updating nested arrays in mongodb
  9. mongodb find by multiple array items
  10. How to filter an array of objects based on values in an inner array with jq?
  11. Can an array be top-level JSON-text?
  12. How to check if element exists in array with jq
  13. Using jsonb_set() for updating specific jsonb array value
  14. Swift 4 JSON Decodable with multidimensional and multitype array
  15. Get particular element from mongoDB array [duplicate]
  16. MongoDB – Query on the last element of an array?
  17. MongoDB update multiple records of array [duplicate]
  18. How to output serialized JSON view data as an array of objects, instead of wrapped in an outer object?
  19. Remove a field from all elements in array in mongodb [duplicate]
  20. Create a Single-Element Json Array Object Using PowerShell
  21. Updating nested array inside array mongodb [duplicate]
  22. $in requires an array as a second argument, found: missing
  23. Swift 4 JSON Codable – value returned is sometimes an object, others an array
  24. How can I decode a JSON response with an unknown key in Swift?
  25. Removing the array element in mongoDB based on the position of element
  26. How to deserialize dodgy JSON (with improperly quoted strings, and missing brackets)?
  27. YAML equivalent of array of objects in JSON
  28. Querying MongoDB to match in the first item in an array
  29. Can you have mongo $push prepend instead of append?
  30. jq: recursively merge objects and concatenate arrays

Leave a Comment