查询
db.getCollection('HistoryData').find({"deviceId":201,"dictValue":8007,"createTime":{"$gte":ISODate("2023-10-09T09:38:00.046+08:00"),"$lte":ISODate("2023-10-09T09:46:00.046+08:00")}}).sort({"createTime":1})
聚合
db.getCollection('HistoryData').aggregate([
{
$match: {
"deviceId":201,
"dictValue":8007,
"createTime":{"$gte":ISODate("2023-10-09T02:00:00.046+08:00"),"$lte":ISODate("2023-10-09T10:00:00.046+08:00")}
}
},
{
$group: {
_id: null,
maxQty: { $max: {
$toDouble: "$dataValue"
}
},
},
},
{
$project: {
_id: 0
},
},
])