Mongo在嵌套对象中查找一组字段

Question

我在mongo db中有一个下面的结构

{
    "_id" : ObjectId("58e8d3323fe482ef368b4567"),
    "productId" : "poe10001134",
    "batchdetails" : [ 
        {
            "batchidId" : "BD0166",
            "batchno" : "BbfN-1444-SBRPX"
         },
        {
            "batchidId" : "BD0167",
            "batchno" : "Bff-8444-kfkff"
         },
         {
            "batchidId" : "BD01447",
            "batchno" : "Bff-8415-kfkff"
         }
]
}

我想要达到以下结果

"productId“："poe10001134”

"batchno“："Bff-8415-kfkff”

当我执行以下查询时

db.getCollection('table').findOne( {"batchdetails.batchidId" : "BD01447"},{productId:1,"batchidId.batchno":1})

它返回所有批号

"productId“："poe10001134”

"batchno“："BbfN-1444-SBRPX”

"batchno“："Bff-8444-kfkff”

"batchno“："Bff-8415-kfkff”

Answer 1

如下所示：

db.getCollection('table').findOne( {"batchdetails.batchidId" : "BD01447"},
    {productId:1,"batchidId.batchno.$":1})

投影中的$包含查询中匹配的batchno数组元素的索引。