MongoDB - Rename fields in aggregation pipeline

Question

This is the document I get after an aggregation query:

{
  _id: <some id>,
  name: 'xxxx',
  sales: {
    saleDate: 'dddddd',
    saleValue: 9999
  }
}

I need to rename the sales field to sale, I know I can use a projection at the end of my aggregation pipeline like this:

[
  //... other aggregation stages before,
  {
    $project: {
      sale: '$sales'
    }
  }
]

But the problem with that approach is that now I have to specify all the remaining fields in the projection otherwise I will get only the sale field in the response, in this example I only have 3 fields but in my project I have much more than that.

So is there another way to rename a field in an aggregation pipeline?

Wernfried Domscheit · Accepted Answer · 2023-01-29 21:24:14Z

4

Try this:

{
  $set: {
    sale: '$sales'
    sales: '$$REMOVE'
  }
}

answered Jan 29, 2023 at 21:24

Wernfried Domscheit

60.4k10 gold badges93 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Rename fields in aggregation pipeline

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