Search code examples
mongodbmongodb-queryaggregation-framework

$replaceRoot in mongodb


I use aggregation framework for group by of multiple fields as

{
_id:{_id:"$_id",feature_type:"$feature_type",feature_name:"$feature_name"},
features: { $push: "$features" }
}

it give result like

{_id:
     {_id:1,feature_type:"Test",feature_name:"Tests"},
  features:["23423","32423","2342342"]
}

but I want result like

{_id:1,feature_type:"Test",feature_name:"Tests",
  features:["23423","32423","2342342"]
}

how can i acheve this using aggregration framework.


Solution

  • db.collection.aggregate([
      {      
          $project: {
                    _id: "$_id._id",
                    feature_type:"$_id.feature_type",
                    feature_name:"$_id.feature_name",
                    features:1
                    }
      }
    ])