MongoDB - Move top field into each element of array

Question

I have the following MongoDB query:

db['foo'].aggregate([
{ $project: {
    frame: {
        frame_id: "$frameProfileId",
        sections: {
            $filter: {
                input: "$sections",
                cond: { $eq: [ "$$frameSection.metadata.subType", "Quaternion"] },
                as: "frameSection"
                }
            }
        }
    }
},
{ $unwind: "$frame"},
{ $replaceRoot: { newRoot: "$frame"}}
])

which produces:

[
  {
    frame_id: '366',
    sections: [
      {
        title: 'This is a bogus title',
        count: 1,
        metadata: {
          subType: 'Quaternion',
          edgeCount: 1
        }
      },
      {
        title: 'Plan b',
        count: 6,
        metadata: {
          subType: 'Quaternion',
          edgeCount: 1
        }
      }
    ]
  },
  { 
    frame_id: '388',
    sections: [
      {
        title: 'Another title',
        count: 14,
        metadata: {
          subType: 'Quaternion',
          edgeCount: 1
        }
      }
    ]
  }
]

What I want to accomplish is to move the frame_id inside the elements like so:

[
  {
    sections: [
      {
        frame_id: '366',
        title: 'This is a bogus title',
        count: 1,
        metadata: {
          subType: 'Quaternion',
          edgeCount: 1
        }
      },
      {
        frame_id: '366',
        title: 'Plan b',
        count: 6,
        metadata: {
          subType: 'Quaternion',
          edgeCount: 1
        }
      }
    ]
  },
  { 
    sections: [
      {
        frame_id: '388',
        title: 'Another title',
        count: 14,
        metadata: {
          subType: 'Quaternion',
          edgeCount: 1
        }
      }
    ]
  }
]

I had a go at $addField, $set, $push and $[] but I can't quite accomplish it in the context of a query like this.

Yong Shun · Accepted Answer · 2022-10-05 09:39:18Z

1

$map - Iterate each document in filtered sections array and return a new array.

1.1. $mergeObjects - Merge current iterated document with the document contains frame_id field.

db.collection.aggregate([
  {
    $project: {
      sections: {
        $map: {
          input: {
            $filter: {
              input: "$sections",
              as: "frameSection",
              cond: {
                $eq: [
                  "$$frameSection.metadata.subType",
                  "Quaternion"
                ]
              }
            }
          },
          in: {
            $mergeObjects: [
              "$$this",
              {
                frame_id: "$frameProfileId"
              }
            ]
          }
        }
      }
    }
  }
])

Demo @ Mongo Playground

answered Oct 5, 2022 at 9:39

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Move top field into each element of array

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