mongodb - mongo数组查询,如何仅返回当前匹配数组?
PHP中文网
PHP中文网 2017-04-27 09:02:24
0
4
622
db.test.find();
{
    _id: ObjectId('55e99a2190df7a911d6ed1f1'),
    list: [
        {
            "aa": 10,
            "data": "test"
        },
        {
            "aa": 1,
            "data": "test"
        }
    ]
}

db.test.find({_id: ObjectId('55e99a2190df7a911d6ed1f1'), list: {'$elemMatch': {'aa': 1}}})
预期结果:
{_id: ObjectId('55e99a2190df7a911d6ed1f1'),
list: {
        "aa": 1,
        "data": "test"
}
PHP中文网
PHP中文网

认证高级PHP讲师

reply all(4)
PHPzhong
> 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
        }
    ]
}

Query matching embedded documents, you can also query directly, such as:

> 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
        }
    ]
}

Corresponding to your above query implementation:

> 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()

PHPzhong

First of all, if you use mongodb, you have to understand that mongodb is nosql
Then, the mongo collection stores documents
Finally, you have to know that the value returned by find must be a collection of documents, which is an array

So what you said is basically impossible to achieve

洪涛

Just fill in the query conditions you need in find. For more details, please check the mongodb official website

为情所困

Use the $ operator to return one or more, no way

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template