Update nested object properties by using object ids

Question

Please refer the following data structure that is stored in the database as a single document,

{
  "_id": "objectId",
  "names": [
    {
      "_id": "objectId",
      "first_name": "a",
      "is_used": {
        "hr": false,
        "finance": false
      },
      "alt_names": [
        {
          "_id": "objectId",
          "first_name": "b",
          "is_used": {
            "hr": false,
            "finance": false
          }
        }
      ]
    }
  ]
}

how can we update the alt_names hr: false to hr: true in nested object by using its object id

Is the object you provided in an array of similarly-structured objects? Or do you have a direct reference to this object? — zr0gravity7, Aug 24 '21 at 17:45
Is the `_id` key attached to each item in the `names` list different from the top-level `_id` key? — zr0gravity7, Aug 24 '21 at 17:49
Your question asks how to update it by objectId, but your model has multiple ObjectIDs at multiple levels. Which one are you referring to? — barrypicker, Aug 24 '21 at 22:19

score 0 · Answer 1 · answered Aug 24 '21 at 17:48

const documents = [];
const targetDocumentId = "foo";

const targetDocument = documents.find(document => document._id === targetDocumentId);

const targetNameId = "bar";

const targetName = targetDocument.names.find(name => name._id === targetNameId);

if (targetName) {
  if (targetName.hasOwnProperty("alt_names")) {
    targetName.alt_names.is_used.hr = true;
  }
}

YuTing · Answer 2 · 2021-08-25T01:03:06.580

0

Your mongodb version should be at least 3.6, and code below is what you need.

db.collection.update(
    { "names.alt_names._id": "objectId" },
    { $set: { "names.$[].alt_names.$[filter].is_used.hr": true } },
    { arrayFilters: [{ 'filter._id': 'objectId' }] }
);

Reference are below.

Update an object in nested Array
MongoDB 3.6: Array Filters
Positional Operator Matching Nested Arrays

edited Aug 25 '21 at 01:03

answered Aug 25 '21 at 00:44

YuTing

6,555
2
6
16

Update nested object properties by using object ids

2 Answers2