mongodb 时间做位查询条件问题

Question

数据结构是

{
    "_id" : ObjectId("59e05fa63e0f5015dcaeadbe"),
    "name" : "santu",
    "mes" : "测试留言1",
    "time" : ISODate("2017-10-13T06:39:34.273Z"),
    "replay" : [ 
        {
            "time" : ISODate("2017-10-13T06:39:55.365Z"),
            "_id" : ObjectId("59e05fbb3e0f5015dcaeadbf"),
            "replayer" : "santu",
            "replaymes" : "测试留言回复1"
        }, 
        {
            "time" : ISODate("2017-10-16T06:03:36.188Z"),
            "_id" : ObjectId("59e44bb81f111527f8dc8bd1"),
            "replayer" : "santubaby",
            "replaymes" : "测试留言回复33333"
        }
    ],
    "__v" : 0
}

db.mesModel.aggregate(
    {"$project":{"replay":"$replay"}},
    {"$unwind":"$replay"},
    {"$match":{"replay.replaymes":'测试留言回复33333','replay.time':'ISODate("2017-10-16T06:03:36.188Z")'}},(e,d)=>{
      console.log(d)
    }
)

这样查询的话打印了空集，但是将replay.time改成replay.replayer:'xxx'的话就能正常匹配了 求大腿子求教

Answer 1

'replay.time':'ISODate("2017-10-16T06:03:36.188Z")'

===>

'replay.time':ISODate("2017-10-16T06:03:36.188Z")

试试看