建议参考官方文档真详细
Spring Data MongoDB - Reference Documentation
使用Spring访问Mongodb的方法大全——Spring Data MongoDB查询指南 - JadePeng - 博客园
字段下面的list中字段值的查询判断
query.addCriteria(Criteria.where("rulesItem.bussinessType.value").regex(reqDTO.getBussinessType(), "i"));
spring-data-mongodb之Aggregation - 简书
排序后取出第一个
User findFirstByOrderByLastnameAsc();
User findTopByOrderByAgeDesc();
Page<User> queryFirst10ByLastname(String lastname, Pageable pageable);
Slice<User> findTop3ByLastname(String lastname, Pageable pageable);
List<User> findFirst10ByLastname(String lastname, Sort sort);
List<User> findTop10ByLastname(String lastname, Pageable pageable);
mango做聚合操作
mango
db.getCollection('agent').aggregate([ {$group: {_id : {"officeCode":"$officeCode", "segOrgn":"$segOrgn"，"segDstn:$segDstn"}, num: {$sum : 1}}} ])
java
public List<AgentDO1> aggregate()
{
Aggregation aggregation1 = Aggregation.newAggregation(Aggregation.group("officeCode:$officeCode","segOrgn:$segOrgn","segDstn:$segDstn").count().as("num"));
AggregationResults<AgentDO1> outputTypeCount1 =
mongoTemplate.aggregate(aggregation1, "agent", AgentDO1.class);
List<AgentDO1> tagCount = outputTypeCount1.getMappedResults();
return tagCount;
}
mango有子列表做聚合操作
public List<SalesExceptionResultDO1> aggregateSales() {
Aggregation aggregation1 = Aggregation.newAggregation(Aggregation.unwind("resultList"),
Aggregation.group("startDate:$startDate","endDate:$endDate","officeCode:$resultList.officeCode", "segOrgn:$resultList.segOrgn", "segDstn:$resultList.segDstn").count().as("num"));
AggregationResults<SalesExceptionResultDO1> outputTypeCount1 = mongoTemplate.aggregate(aggregation1,
"sales_exception", SalesExceptionResultDO1.class);
List<SalesExceptionResultDO1> tagCount = outputTypeCount1.getMappedResults();
return tagCount;
}
