MongoDB提取文档
MongoDB提取文档
提问于 2021-11-11 19:16:07
我有个Json：
{
"_id": {
"$oid": "613a55dccXXXXXXX28b5ba3a1"
},
"user": "CHEWBACCA",
"paymentTypes": [{
"type": "PILOT",
"limits": [{
"type": "FLIGHT_HOURS",
"amount": 10
},
{
"type": "COMBAT_HOURS",
"amount": 80000
},
{
"type": "TRAINING_HOURS",
"amount": 80000
}
]
},
{
"type": "WARRIOR",
"limits": [{
"type": "FLIGHT_HOURS",
"amount": 22
},
{
"type": "COMBAT_HOURS",
"amount": 123
},
{
"type": "TRAINING_HOURS",
"amount": 456
}
]
}
],
"createdDate": "2021-11-11"
}我想对paymentType.type =“引导”和限制等于类型等于"COMBAT_HOURS“进行独家过滤。
这是我希望得到的结果。
{
"_id": {
"$oid": "613a55dccXXXXXXX28b5ba3a1"
},
"user": "CHEWBACCA",
"paymentTypes": [{
"type": "PILOT",
"limits": [{
"type": "COMBAT_HOURS",
"amount": 80000
}]
}],
"createdDate": "2021-11-11"
}如何提取文档以达到此结果？
回答 1
Stack Overflow用户
回答已采纳
发布于 2021-11-11 20:13:40
查询
- 地图
paymentTypes - 如果是
paymentType= PILOT，过滤限制只保留战斗时间 - 否则
null(我们不想要那个paymentType) - 删除空值(那些空值不是paymentTypes类型的导频)
*这可能导致空数组，无论是在paymentTypes上还是在限制上，如果您不接受空数组，则可以匹配并删除这些空数组。
aggregate(
[{"$addFields":
{"paymentTypes":
{"$map":
{"input": "$paymentTypes",
"in":
{"$cond":
[{"$eq": ["$$ptype.type", "PILOT"]},
{"$mergeObjects":
["$$ptype",
{"limits":
{"$filter":
{"input": "$$ptype.limits",
"cond": {"$eq": ["$$this.type", "COMBAT_HOURS"]}}}}]},
null]},
"as": "ptype"}}}},
{"$addFields":
{"paymentTypes":
{"$filter":
{"input": "$paymentTypes", "cond": {"$ne": ["$$this", null]}}}}}])页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/69933707
复制相关文章
相似问题
腾讯云开发者
