如何在mongodb文档中的数组内应用mongodb查找_id

Question

我面临的问题在运行mogodb聚合查找函数对数组对象id的文档我有两个来自不同表格的文档部门表文档

{
"_id" : ObjectId("60b5d01d3cad3268ec30a4db"),
"designationId" : [ 
ObjectId("60b5d6483cad3268ec30a513")
],
"creationTime" : 1622525747967.0,
"isActive" : true,
"name" : "CT Dept One",
"organizationId" : ObjectId("60b5cf7d3cad3268ec30a4c7"),
"brandUserId" : ObjectId("60ae11608646230e9cea8ee9"),
"createdby" : ObjectId("60ae11608646230e9cea8ee9"),
"createdAt" : ISODate("2021-06-01T06:13:49.639Z"),
"updatedAt" : ISODate("2021-06-01T06:40:08.453Z"),
"__v" : 1
}

名称表

{
"_id" : ObjectId("60b5cf7d3cad3268ec30a4c7"),
"creationTime" : 1622525747965.0,
"isActive" : true,
"name" : "CT PVT LTD",
"brandUserId" : ObjectId("60ae11608646230e9cea8ee9"),
"createdby" : ObjectId("60ae11608646230e9cea8ee9"),
"createdAt" : ISODate("2021-06-01T06:11:09.783Z"),
"updatedAt" : ISODate("2021-06-01T06:11:09.783Z"),
"__v" : 0
}

我已经尝试了这里提到的每一个解决方案Mongodb $查找数组的对象/文档从指定表中获取数据到部门表。请帮我解决这个问题。

Answer 1

Documents.aggregate([{
$lookup:{
form:"DesignationsCollection" // Designations collection name
localField:"designationId"
foreignField:"_id"
as : "designation"
}
}])