要求:按fruits数量进行排序查询结果
MongoDB数据结构:
{ "_id": "123456", "url": "", "name": "水果1", "fruits": [ { "id": "apple", "name": "苹果" } ] }
Java代码如下:
// 检索条件
Criteria criteria = Criteria.where("name").ne(null);
// // 查询节点及数组节点大小计算$size
// ProjectionOperation projectionOperation = Aggregation.project("name", "url");
//
// // "fruitSize": { "$size": ["$fruits"] }
// projectionOperation.andExpression("size(fruits)").as("fruitSize");
// 不能拆开,否则this映射有问题,导致fruitSize不能加入project中
ProjectionOperation projectionOperation = Aggregation.project("name", "url").andExpression("size(fruits)").as("fruitSize");
Aggregation aggregationAll = Aggregation.newAggregation(
Aggregatio