MongoDB:在同一嵌入文档中进行匹配的查询

kyks70gy  于 2022-09-18  发布在  Go
关注(0)|答案(0)|浏览(89)

帮助我匹配这两个条件的单个嵌入文档。

db.inventory.insertOne([
...     { "item": "journal", "instock": [ { "warehouse": "A", "qty": 5 }, { "warehouse": "C", "qty": 15 } ] },
...     { "item": "notebook", "instock": [ { "warehouse": "C", "qty": 5 } ] },
...     { "item": "paper", "instock": [ { "warehouse": "A", "qty": 60 }, { "warehouse": "B", "qty": 15 } ] },
...     { "item": "planner", "instock": [ { "warehouse": "A", "qty": 40 }, { "warehouse": "B", "qty": 5 } ] },
...     { "item": "postcard", "instock": [ { "warehouse": "B","qty": 15 }, { "warehouse": "C", "qty": 35 } ] }
... ])

预期返回与查询完全匹配的单个文档,但返回两个文档。

db.inventory.find( { "instock.qty": 5, "instock.warehouse": "A" } )
{ "_id" : ObjectId("63061a1bb87c1278047a2717"), "item" : "journal", "instock" : [ { "warehouse" : "A", "qty" : 5 }, { "warehouse" : "C", "qty" : 15 } ] }
{ "_id" : ObjectId("63061a1bb87c1278047a271a"), "item" : "planner", "instock" : [ { "warehouse" : "A", "qty" : 40 }, { "warehouse" : "B", "qty" : 5 } ] }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题