Zona de juegos https://mongoplayground.net/p/tIMLOtWTnno
DATOS:
[ { "_id": "1", "data": { // How to remove this "data" Field "colour": "Blue", "size": "12", } }, { "_id": "2", "data": { // How to remove this "data" Field "colour": "Silver", "size": "20", } } ] Quiero eliminar el campo data .
Rendimiento esperado:
[ { "_id": "1", "colour": "Blue", "size": "12", }, { "_id": "2", "colour": "Silver", "size": "20", } ]Lo intenté así:
db.collection.aggregate({ $project: { _id: 1, data: { $objectToArray: "$data" } }, }, { $unwind: "$data" }, { $project: { "$data.k": "$data.v" } })Como hacer esto ?
consulta1
* también puedes usar proyecto
aggregate( [{"$set": {"colour":"$data.colour", "size":"$data.size", "data":"$$REMOVE"}}])consulta2
aggregate( [{"$replaceRoot":{"newRoot":{"$mergeObjects":["$data", "$$ROOT"]}}}, {"$project":{"data":0}}])