Add field to every object in array of objects in mongo aggregation

Question

I have one field in schema at root level and want to add it in every object from array which matches a condition.

Here is a sample document....

{
    calls: [
      {
        "name": "sam",
        "status": "scheduled"
      },
      {
        "name": "tom",
        "status": "cancelled"
      },
      {
        "name": "bob",
        "status": "scheduled"
      },
      
    ],
    "time": 1620095400000.0,
    "call_id": "ABCABCABC"
}

Required document is as follows:

[
  {
    "call_id": "ABCABCABC",
    "calls": [
      {
        "call_id": "ABCABCABC",
        "name": "sam",
        "status": "scheduled"
      },
      {
        "name": "tom",
        "status": "cancelled"
      },
      {
        "call_id": "ABCABCABC",
        "name": "bob",
        "status": "scheduled"
      }
    ],
    "time": 1.6200954e+12
  }
]

The call_id should be added to all objects in array whose status is "scheduled". Is it possible to do this with mongo aggregation? I have tried $addFields but was unable to achieve above result. Thanks in advance!

Tom Slabbaert · Accepted Answer · 2021-05-04 13:15:53Z

6

Here is how I would do it using $map and $mergeObjects

db.collection.aggregate([
  {
    "$addFields": {
      calls: {
        $map: {
          input: "$calls",
          as: "call",
          in: {
            $cond: [
              {
                $eq: [
                  "$$call.status",
                  "scheduled"
                ]
              },
              {
                "$mergeObjects": [
                  "$$call",
                  {
                    call_id: "$call_id"
                  }
                ]
              },
              "$$call"
            ]
          }
        }
      }
    }
  }
])

Mongo Playground

answered May 4, 2021 at 13:15

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Add field to every object in array of objects in mongo aggregation

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