MongoDB update arrays entry

Question

I have a document to Mongodb update array of objects like this:

    {
    "myArray": [
            {
              "Key1": "string",
              "key2": {
                "entry": "aaa"
              }
            },
            {
              "Key1": "string",
              "key2": {
                "entry": "bbb"
              }
            }
          ]
    }

And I want to modify the key2 field in each object of myArray. The expected result should be :

    {
    "myArray": [
            {
              "Key1": "string",
              "key2Modified":"aaa"
            },
            {
              "Key1": "string",
              "key2Modified":"bbb"
            }
          ]
    }

Any help please ?

Check out the array update operators and arrayFilters.

Joe
– Joe

2021-11-12 23:22:37 +00:00
Commented Nov 12, 2021 at 23:22 — Joe
– Joe, Commented Nov 12, 2021 at 23:22

YuTing · Accepted Answer · 2021-11-13 00:29:50Z

1

use $map in $set

db.collection.update({},
[
  {
    $set: {
      "myArray": {
        $map: {
          input: "$myArray",
          as: "a",
          in: {
            Key1: "$$a.Key1",
            key2Modified: "$$a.key2.entry"
          }
        }
      }
    }
  }
])

mongoplayground

answered Nov 13, 2021 at 0:29

YuTing

6,6692 gold badges8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB update arrays entry

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related