I have the following aggregation:
db.runCommand(
{"aggregate":"Order","pipeline":[
{"$match":{"shopId":28440395907}},
{"$match":{"createdAt":{"$gte":{"$date":{"$numberLong":"0"}}}}},
{"$sort":{"updatedAt":-1}},
{"$facet":{"results":[{"$skip":0},{"$limit":25}],"count":[{"$count":"count"}]}}
],"allowDiskUse":true,"cursor":{}}
);
The problem is that it fails to return any results. Replacing the date filter with literally anything else provides results so my guess is that there is a problem with date conversion. I tried all the versions I found in tutorials (like new Date("2015-06-17 10:03:46.000Z")), it always acts the same. Can anyone please explain why and how to fix?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…