mongo 查询语句 https://paste.ubuntu.com/p/MHQBDVd3jP/
springdatamongo 查询:
Aggregation agg = Aggregation.newAggregation(
Aggregation.match(Criteria.where("deviceNo").in(deviceNos)),
Aggregation.project().and(StringOperators.SubstrCP.valueOf("$hour").substringCP(8, 2)).as("h")
.and("$statistics.EPI.diffsum").as("diffsum"),
Aggregation.group("$h").sum("$diffsum").as("epidiffsum"),
Aggregation.sort(Sort.Direction.ASC, "_id")
);
Xica 更改状态以发布
MongoDB中文社区