主集合文档包含工作流详细信息。每个工作流详细信息都有一个工作流状态对象，并且链接中有一个对象数组。
当 from.nodeId = "value" 时，我需要从 links 数组中找到所有匹配的对象
{
"workflowId": "YNmwuXwQKElY",
"name": "Hello ",
"workflowState": {
"searchType": "tasks",
"links": [
{
"id": "67dca090-dd7a-4b86-8522-456ccdb891b2",
"from": {
"nodeId": "NecHqBJvxk",
"portId": "port1"
},
"to": {
"nodeId": "NecHqBJvxk",
"portId": "port2"
}
},
{
"id": "9b7a4d78-d4e6-4229-a091-24f87e3e1fa4",
"from": {
"nodeId": "PEfgrTpFOB",
"portId": "port2"
},
"to": {
"nodeId": "nUjhZhIwky",
"portId": "port1"
},
"headerValue": "Identifiers"
},
{
"id": "6e3fb202-7e29-46e0-b940-a4908ae8bb95",
"from": {
"nodeId": "NecHqBJvxk",
"portId": "port2"
},
"to": {
"nodeId": "PEfgrTpFOB",
"portId": "port1"
},
"headerValue": "Conditions",
}
],
"hovered": {},
},
"archive": true
}
我试过这个查询
db.collection.find({
"workflowState.links": {
$elemMatch: {
"from.nodeId": "NecHqBJvxk"
}
}
},
{
"workflowState.links.$": 1
})
但它只返回数组中的第一个匹配项。
我期望这种格式的输出。
{
"_id": ObjectId("5a934e000102030405000000"),
"workflowState": {
"links": [
{
"from": {
"nodeId": "NecHqBJvxk",
"portId": "port1"
},
"id": "67dca090-dd7a-4b86-8522-456ccdb891b2",
"to": {
"nodeId": "NecHqBJvxk",
"portId": "port2"
}
},
{
"id": "6e3fb202-7e29-46e0-b940-a4908ae8bb95",
"from": {
"nodeId": "NecHqBJvxk",
"portId": "port2"
},
"to": {
"nodeId": "PEfgrTpFOB",
"portId": "port1"
},
"headerValue": "Conditions"
}
]
}
}
如何从符合条件的数组中获取对象的所有元素？
提前致谢
在 $unwind 阶段使用聚合函数
db.collection.aggregate([
// Match possible documents
{ "$match": {
"workflowState.links.from.nodeId": "NecHqBJvxk"
}},
// Unwind each array
{ "$unwind": "$workflowState.links" },
// Filter just the matching elements
{ "$match": {
"workflowState.links.from.nodeId": "NecHqBJvxk"
}},
// Group to inner array
{ "$group": {
"_id": "$_id",
"links": { "$push": "$workflowState.links" }
}},
{
"$project":{
_id: "$_id",
"workflowState.links": "$links",
}
}
]);
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句