[{
"username":"user1",
"products":[
{"productID":1,"itemCode":"CODE1"},
{"productID":2,"itemCode":"CODE1"},
{"productID":3,"itemCode":"CODE2"},
]
},
{
"username":"user2",
"products":[
{"productID":1,"itemCode":"CODE1"},
{"productID":2,"itemCode":"CODE2"},
]
}]
我想找到所有"products"中"itemCode"为"CODE1"的"productID",并且这些产品是"用户1"所拥有的。
应该如何编写MongoDB查询语句呢?
$match
->$unwind
->$replaceRoot
->$match
->$project
。 - aderchox