mongodb - mongo數組查詢，如何僅傳回目前匹配數組？

Question

雷雷

Answer 1

> db.customer.find().pretty()
{
    "_id" : ObjectId("559bb1d1d39f0dcac2658f8e"),
    "cust_id" : "abc123",
    "ord_date" : ISODate("2012-10-03T16:00:00Z"),
    "status" : "A",
    "price" : 25,
    "items" : [
        {
            "sku" : "mmm",
            "qty" : 5,
            "price" : 2.5
        },
        {
            "sku" : "nnn",
            "qty" : 5,
            "price" : 2.5
        }
    ]
}
{
    "_id" : ObjectId("559bb1ead39f0dcac2658f8f"),
    "cust_id" : "abc123",
    "ord_date" : ISODate("2012-10-03T16:00:00Z"),
    "status" : "B",
    "price" : 30,
    "items" : [
        {
            "sku" : "mmm",
            "qty" : 6,
            "price" : 3.5
        },
        {
            "sku" : "nnn",
            "qty" : 6,
            "price" : 3.5
        }
    ]
}
{
    "_id" : ObjectId("559bb200d39f0dcac2658f90"),
    "cust_id" : "abc123",
    "ord_date" : ISODate("2012-10-03T16:00:00Z"),
    "status" : "C",
    "price" : 35,
    "items" : [
        {
            "sku" : "mmm",
            "qty" : 7,
            "price" : 4.5
        },
        {
            "sku" : "nnn",
            "qty" : 7,
            "price" : 4.5
        }
    ]
}
> db.customer.find({"items.qty":6},{"items.$":1}).pretty()  //只返回和查询条件匹配的那一个元素  
{
    "_id" : ObjectId("559bb1ead39f0dcac2658f8f"),
    "items" : [
        {
            "sku" : "mmm",
            "qty" : 6,
            "price" : 3.5
        }
    ]
}

查詢匹配的內嵌文檔，你也可以直接查詢，如：

> db.customer.find({"items.qty":6}).pretty()
{
    "_id" : ObjectId("559bb1ead39f0dcac2658f8f"),
    "cust_id" : "abc123",
    "ord_date" : ISODate("2012-10-03T16:00:00Z"),
    "status" : "B",
    "price" : 30,
    "items" : [
        {
            "sku" : "mmm",
            "qty" : 6,
            "price" : 3.5
        },
        {
            "sku" : "nnn",
            "qty" : 6,
            "price" : 3.5
        }
    ]
}

對應你上面的查詢實作：

> db.customer.find({"_id":ObjectId("559bb1ead39f0dcac2658f8f"),items: {'$elemMatch': {'sku': "mmm"}}},{"items.$":1}).pretty()
{
    "_id" : ObjectId("559bb1ead39f0dcac2658f8f"),
    "items" : [
        {
            "sku" : "mmm",
            "qty" : 6,
            "price" : 3.5
        }
    ]
}

db.test.find({_id: ObjectId('55e99a2190df7a911d6ed1f1'), list: {'$elemMatch': {'aa': 1}}},{"list.$":1}).pretty()

Answer 2

首先 你用mongodb 你得明白 monggodb是nosql
然後 mongo的collection中儲存的是document
最後 你要知道 find 回傳的值一定是一個document的集合 也就是個array

所以你說的 基本上無法實現

Answer 3

只需要在find中填寫你需要的查詢的條件即可。更多詳情，請參閱mongodb官網

Answer 4

使用 $ 運算子能回傳一個 多個的話 沒門