How to flatted nested keys into the top level object in Mongoose

Question

I have documents like so:

[
  {
    title: 'apple',
    attributes: {
      colour: 'red',
      kind: 'fruit'
  },
  {
    title: 'broccoli',
    attributes: {
      colour: 'green',
      kind: 'vegetable'
    }
  },
]

In my aggregation pipeline, I want to essentially flatten the hierarchy one level deep, such that it looks like this:

[
  {
    title: 'apple',
    colour: 'red',
    kind: 'fruit'
  },
  {
    title: 'broccoli',
    colour: 'green',
    kind: 'vegetable'
  }
]

The thing is, the keys in the nested object are dynamic across documents, so I wouldn't be able to $project them statically. I need to dynamically pull these nested key/value pairs to the top object.

R2D2 · Accepted Answer · 2022-05-05 13:01:13Z

6

Maybe something like this using the aggregation framework:

db.collection.aggregate([
{
 $replaceRoot: {
  newRoot: {
    $mergeObjects: [
      "$$ROOT",
      "$attributes"
    ]
   }
  }
 },
 {
 $project: {
   attributes: 0
   }
 }
])

Explained:

ReplaceRoot with merged object between the root object & attributes
Remove the attributes object from the output.

playground

answered May 5, 2022 at 13:01

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

How to flatted nested keys into the top level object in Mongoose

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related