json - 如何在MongoDB中查找与数组类型字段中的值匹配的文档

Question

{      
    "_id" : ObjectId("5b98e5d17d542a2560ec026d"), 
    "RequestID" : "1536746958",     
    "JSON_Request" : [2,"1536746958","Heartbeat",{}],    
    "JSON_Response" : [3,"1536746958",{"currentTime":"2018-09-12T10:09:21.435Z"}] 
}

想要在“JSON_Request”字段中获取包含“心跳”的文档

标签： jsonmongodb

Answer 1

您可以使用$inMongoDB 的运算符。官方文档链接：点击

示例：我在 queryAns 集合中有两个文档为

db.queryAns.find({}).pretty()

{
    "_id" : ObjectId("5b98e5d17d542a2560ec026d"),
    "RequestID" : "1536746958",
    "JSON_Request" : [
        2,
        "1536746958",
        "Heartbeat1",
        {

        }
    ],
    "JSON_Response" : [
        3,
        "1536746958",
        {
            "currentTime" : "2018-09-12T10:09:21.435Z"
        }
    ]
}
{
    "_id" : ObjectId("5b98e5d17d542a2560ec024d"),
    "RequestID" : "1536746958",
    "JSON_Request" : [
        2,
        "1536746958",
        "Heartbeat",
        {

        }
    ],
    "JSON_Response" : [
        3,
        "1536746958",
        {
            "currentTime" : "2018-09-12T10:09:21.435Z"
        }
    ]
}

并仅过滤掉“JSON_Request”中包含“Heartbeat”的结果，

db.queryAns.find({"JSON_Request": {$in: ["心跳"]}}).pretty()

{
    "_id" : ObjectId("5b98e5d17d542a2560ec024d"),
    "RequestID" : "1536746958",
    "JSON_Request" : [
        2,
        "1536746958",
        "Heartbeat",
        {

        }
    ],
    "JSON_Response" : [
        3,
        "1536746958",
        {
            "currentTime" : "2018-09-12T10:09:21.435Z"
        }
    ]
}