具有以下文档:
{
"_id" : ObjectId("xxx"),"seller" : {
"phone" : {
"number" : "xx"
},"nickname" : "xx"
},"shipping" : {
"id" : xx
},"id" : yyy,"order_items" : {
"item" : {
"title" : "xxxyy"
},"quantity" : 1
}}
我需要转换为该输出
{
"_id" : ObjectId("xxx"),"seller.phone.number" : "xx","seller.nickname" : "xx","shipping.id" : "xx","order_items.item.title" :"xxxyy","order_items.quantity" : 1
}
如您所见,我需要做的是将文档展平到单个级别 我正在尝试以下代码,但mi输出静止图像会被嵌套
db.getcollection("collection").aggregate(
[
{
"$unwind" : {
"path" : "$order_items"
}
},{
"$project" : {
"seller.phone.number" : 1.0,"seller.nickname" : 1.0,"shipping.id" : 1.0,"id" : 1.0,"order_items.item.title" : 1.0,"order_items.quantity" : 1.0
}
}
],{
"allowDiskUse" : false
}
);
我开始与mongodb和studio3t合作,将不胜感激 问候