arrays - 使用 elemMatch 的 MongoDB 查询，用于从对象内部匹配嵌套数组数据
问题描述
使用 elemMatch 的 MongoDB 查询，用于匹配对象内部的嵌套数组数据。这里我们有三个项目对象，每个对象都包含一个包含多个对象的考试数组。在这里"project_id" : ObjectId("5b6959e3dc68d21c6613c82d")，"exams"数组包含两次"writer.user_id":ObjectId("5b6959e3dc68d21c6613c77d")
我怎么能从第一个项目对象中过滤这两个数据？
db.exams.insert([{
"project_id" : ObjectId("5b6959e3dc68d21c6613c82d"),
"exams" : [
{
"allotment_type" : "manual",
"exam_id" : 1,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77d"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 1,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 1,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
},
{
"allotment_type" : "manual",
"exam_id" : 2,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77e"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 2,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 2,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
},
{
"allotment_type" : "manual",
"exam_id" : 3,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77d"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 3,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 3,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
}]
},
{
"project_id" : ObjectId("5b6959e3dc68d21c6613c82e"),
"exams" : [
{
"allotment_type" : "manual",
"exam_id" : 1,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77d"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 1,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 1,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
},
{
"allotment_type" : "manual",
"exam_id" : 2,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77e"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 2,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 2,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
},
{
"allotment_type" : "manual",
"exam_id" : 3,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77c"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 3,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 3,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
}]
},
{
"project_id" : ObjectId("5b6959e3dc68d21c6613c82f"),
"exams" : [
{
"allotment_type" : "manual",
"exam_id" : 1,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77d"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 1,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 1,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
},
{
"allotment_type" : "manual",
"exam_id" : 2,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77e"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 2,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 2,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
},
{
"allotment_type" : "manual",
"exam_id" : 3,
"topic" : "something",
"word_count" : 5,
"key_word_density" : 2,
"writer" : {
"user_id" : ObjectId("5b6959e3dc68d21c6613c77c"),
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"editor" : {
"user_id" : 3,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
},
"manager" : {
"user_id" : 3,
"versions" : [
{
"id" : 1,
"file_path" : "abcd"
},
{
"id" : 2,
"file_path" : "abcd"
},
{
"id" : 3,
"file_path" : "abcd"
}
]
}
}]
}]);
解决方案
您可以尝试$filter聚合
db.collection.aggregate([
{ "$project": {
"exams": {
"$filter": {
"input": "$exams",
"as": "exam",
"cond": {
"$eq": [ "$$exam.writer.user_id", ObjectId("5b6959e3dc68d21c6613c77d") ]
}
}
}
}}
])
推荐阅读
- java - IClientConfig 参数的用途是什么？
- json - PostgreSQL 9.5：将 json_agg 结果组合成单个 json 对象
- python - 在python中并行执行'N'个函数
- excel - 基于单元格值隐藏行非常慢
- javascript - 编译和缩小时让 child_process.fork() 在电子中工作
- php - 循环遍历数组并按索引添加到另一个数组
- java - 以用户的设备格式和语言显示日期和时间
- java - 无法在 Spring Boot 中使用 Crud Repository 从 Redis 获取结果？
- php - Laravel 使用 auth()->user() 作为 api
- c - 用 C 语言编程以使用 for 循环查找用户定义的平均值