mongo

查询

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      
    },
  },
 
])