javascript - 重构 MongoDB $lookup Query 的数据。

Question

我希望这是结果帮助我，谢谢

{
    "_id" : ObjectId("5b74f57d3eb9591fcc069406"),
    "received_by" : ObjectId("5b6bac617e9f754ff8aebd65"),
    "received_date" : "2019",
    "code" : "TRSV16081800007",
    "items" : [ 
        {
            "m_souvenir_id" : ObjectId("5b70e98ccb72df3bec00c94a"),
            "qty" : "10"
        },
         {
            "m_souvenir_id" : ObjectId("5b70e98ccb72df3bec00c94a"),
            "qty" : "10"
        },
        
        
    ]
}

结果是这样的

{
    "_id" : ObjectId("5b74f57d3eb9591fcc069406"),
    "received_by" : ObjectId("5b6bac617e9f754ff8aebd65"),
    "received_date" : "2019",
    "code" : "TRSV16081800007",
    "items" : [ 
        {
            "m_souvenir_id" : ObjectId("5b70e98ccb72df3bec00c94a"),
            "qty" : "10"
        }
    ]
}

/* 2 */
{
    "_id" : ObjectId("5b74f57d3eb9591fcc069406"),
    "received_by" : ObjectId("5b6bac617e9f754ff8aebd65"),
    "received_date" : "2019",
    "code" : "TRSV16081800007",
    "items" : [ 
        {
            "m_souvenir_id" : ObjectId("5b70e9d7cb72df3bec00c94b"),
            "qty" : "20"
        }
    ]
}

我在mongodb中有一个nosql项目我在mongodb中有一个nosql问题，我尝试在各种来源中搜索，但结果仍然不是我想要的我在mongodb中有一个这样的项目，

db.t_souvenir.aggregate([
	{ $lookup: { from: "t_souvenir_item", localField:"_id", foreignField:"t_souvenir_id", as: "Items"}},
        { $unwind : "$Items" },
	{ $project : {
	  		"code":1,
	  		"received_by":1,
	  		"received_date":1,
                        items : {
	  		"m_souvenir_id":"$Items.m_souvenir_id",
                        "qty":"$Items.qty",
                        },
	  		
	}};**strong text**

]);

标签： javascriptnode.jsmongodbnosql