Merge document to an array field using mongodb aggregation

Question

I have a collection like;

{
    "_id": ObjectId("5f8069b848e54248f8302b18"),
    "topics": [{
            "_id": "123",
            "name": "ABC",
            "type": 0
        }, {
            "_id": "455",
            "name": "DFR",
            "type": 0
        }
    ],
    "topic": {
        "_id": "777",
        "name": "FFG",
        "type": 123
    }
}

Ho can I write an aggregation query to merge topic to topics?

Just use $unwind and $groupby after that. $unwind will unwind your array and then group by will group them . Use group by Topic.id. docs.mongodb.com/manual/reference/operator/aggregation/unwind — Bahroze Ali
– Bahroze Ali, Commented Mar 4, 2021 at 16:39

GitGitBoom · Accepted Answer · 2021-03-04 16:53:29Z

1

Is topic always unique? (Ie: not already included in topics) If so you can just add it to the array.

https://mongoplayground.net/p/vKv_qjm3VNp

db.collection.aggregate([
  {
    "$project": {
      topics: {
        "$concatArrays": [
          "$topics",
          [
            "$topic"
          ]
        ]
      }
    }
  }
])

answered Mar 4, 2021 at 16:53

GitGitBoom

1,9226 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

Merge document to an array field using mongodb 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