How to move MongoDB document fields to an array of objects?

Question

Given a collection of documents similar to the following document

{
    "_id": {
        "$oid": "60582f08bf1d636f4b762ebc"
    }
    "experience": [{
        "title": "Senior Customer Success Account Manager",
        "company": "Microsoft",
        "tenure": 8
    }, {
        "title": "Senior Service Delivery Manager",
        "company": "Microsoft",
        "tenure": 34
    }],
    "company3": "Oracle",
    "tenure3": 10,
    "title3": "Senior Customer Success Manager - EMEA |Oracle Marketing Cloud"
}

How would I write an updateMany or other shell command to move company3, tenure3 and title3 inside the experience array as a new object {company: <company3 value>, title: <title3 value>, tenure: <tenure3 value>} ?

You would use an Aggregation update - this allows move the three fields (as an object) into the experience array. You can us the $concatArrays operator tp accomplish this. — prasad_
– prasad_, Commented Mar 22, 2021 at 6:44
@Alexandry Raduca, if codemonkey has answered your question and you found his answer helpful, please don't be shy to upvote him and accept with green check button below.. — AlexZeDim
– AlexZeDim, Commented Mar 22, 2021 at 7:11

codemonkey · Accepted Answer · 2021-03-22 07:07:14Z

3

Seems like you're looking for this aggregation update:

db.collection.update({},
[
  {
    $set: {
      experience: {
        $concatArrays: [
          "$experience",
          [
            {
              company: "$company3",
              title: "$title3",
              tenure: "$tenure3"
            }
          ]
        ]
      }
    }
  },
  {
    $unset: "company3"
  },
  {
    $unset: "tenure3"
  },
  {
    $unset: "title3"
  }
],
{
  multi: true
})

Playground: https://mongoplayground.net/p/xoEveE0rdBN

answered Mar 22, 2021 at 7:07

codemonkey

7,9655 gold badges28 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

How to move MongoDB document fields to an array of objects?

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