从MonoDB返回所有字段，该字段与嵌入在Object类型中的字段的值匹配

ke3pup 发表于 Dev

ke3pup

对于以下MongoDB结果，我正在尝试编写一个查询，其中归档的名称不是NOTDemo或Demo 2Items.location是equal to hongkong：

{
    "_id": ObjectID("573ac4d1ad364cd534a03e15"),
    "updatedAt": ISODate("2016-05-17T07:14:25.341Z"),
    "createdAt": ISODate("2016-05-17T07:14:25.341Z"),
    "name": "Testing",
    "Items": {
        "date": "18052016",
        "location": "hongkong"
    },
    "__v": 0
},
{
    "_id": ObjectID("573ac4d1ad364cd534a03e16"),
    "updatedAt": ISODate("2016-05-17T07:14:25.341Z"),
    "createdAt": ISODate("2016-05-17T07:14:25.341Z"),
    "name": "Demo",
    "Items": {
        "date": "18052016",
        "location": "hongkong demo"
    },
    "__v": 0
},
{
    "_id": ObjectID("573ac4d1ad364cd534a03e16"),
    "updatedAt": ISODate("2016-05-17T07:14:25.341Z"),
    "createdAt": ISODate("2016-05-17T07:14:25.341Z"),
    "name": "Demo 2",
    "Items": {
        "date": "18052016",
        "location": "hongkong demo"
    },
    "__v": 0
}

我的查询看起来像：

mySchema.statics.testing = function *() {
    var output =  this.find(
        {
            name: {
                $nin: ["Demo", "Demo 2"]
            }
        }
        ,{
            Items: {
                $elemMatch: { location: "hongkong" }
            }
        }).exec();

    return output;
};

而我的架构如下：

var mongoose = require('mongoose');
var mySchema = new mongoose.Schema({
    name: String,
    Items: Object
}, { timestamps: true });

查询似乎只返回"_id"匹配的字段，因为我要返回所有字段，即名称，Items..etc。我想念什么？

ke3pup

固定的。需要：

var output =  this.find(
        {
            name: {
                $nin: ["Demo", "Demo 2"]
            },
            "Items.location" : "hongkong"
        }).exec();

    return output;
};

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。