我是 MongoDB 的新手。我有兩個名稱adverb和categories. 副詞欄位是
{
"advId": "myid",
"advTitle": "myTitle",
"advDescription": "test description",
"fromUser": "userid",
"subCategoryId": "catid",
"advLabel": "1",
"cityId": "cityid",
"areaName": "areaName",
"chatState": true,
"geoPosition": {
"latitude": 21.61980691353274,
"longitude": 51.519725019871956
},
"advImages": [],
"timeStamp": 1646670847761,
"visibility": false
}
和類別集合與欄位
{
"catId": "catId",
"catTitle": "catTitle",
"catSub": [{
"subId": "subId",
"subTitle": "????????"
}, {
"subId": "subId",
"subTitle": "??????"
}]
}
并且我想將“副詞的 subCategoryId”與“catSub 的類別集合上的 subId”加入 catSub 是一個具有物件值的陣列我該怎么做？tnx。
uj5u.com熱心網友回復：
db.adverb.aggregate([
{
"$lookup": {
"from": "categories",
"localField": "subCategoryId",
"foreignField": "catSub.subId",
"as": "docs"
}
}
])
mongoplayground
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/447455.html
上一篇：無法在terraform版本4.5.0中為多個awss3添加versioning_configuration
下一篇：我的AngularWeb應用程式按預期通過按鈕進行路由，但是當我在url中鍵入頁面路徑時，路由不起作用。在Firebase上托管時