如何将芒果数据库聚合(展开，匹配和项目)查询转换为java代码

Question

我想将此查询转换为具有聚合和条件的java代码，使用$unwind来获取单个文档和$project以获得个性化的响应。

db.getCollection('WarrantyCategory').aggregate([{
$unwind: '$subWarrantyCategories'
},
{
$match: {
$and: [{
$and: [{
'subWarrantyCategories.filtersAllowed.type._id': 'CODE_ACTE'},
{
$and: [{'subWarrantyCategories.filtersAllowed.valuesAutorized.id': 'ORT'}, 
{'subWarrantyCategories.filtersAllowed.valuesAutorized.operator': '='}]
}
]
},
{
$and: [{'subWarrantyCategories.filtersAllowed.type._id': 'TYP_ACCORD'},
{
$and: [{'subWarrantyCategories.filtersAllowed.valuesAutorized.id': 'O'},{'subWarrantyCategories.filtersAllowed.valuesAutorized.operator': '='}]
}]
}
]
}
},
{
$project: {
_id: 0,
label: 1,
code: 1,
labelSCat: '$subWarrantyCategories.label',
CodeSCat: '$subWarrantyCategories._id'}}])

我尝试了一个@Query但没有$unwind的例子，效果很好

Answer 1

弹簧数据的示例代码 mongodb

List<AggregationOperation> stages = new ArrayList<>();
stages.add(unwind("$subWarrantyCategories"));
List<Criteria> andList = new ArrayList<>();
Criteria c1 = new Criteria("subWarrantyCategories.filtersAllowed.type._id").is("CODE_ACTE");
Criteria c2  new Criteria("subWarrantyCategories.filtersAllowed.valuesAutorized.id").is("ORT");
Criteria c3 =  new Criteria("subWarrantyCategories.filtersAllowed.valuesAutorized.operator").is("=");
Criteria c4  new Criteria("subWarrantyCategories.filtersAllowed.type._id").is("TYP_ACCORD");
Criteria c5 =  new Criteria("subWarrantyCategories.filtersAllowed.valuesAutorized.id").is("0");
Criteria c5 =  new Criteria("subWarrantyCategories.filtersAllowed.valuesAutorized.operator").is("=");

andList.add(new Criteria().andOperator(c1, new Criteria().andOperator(c2,c3)));
andList.add(new Criteria().andOperator(c4, new Criteria().andOperator(c5,c6)));
stages.add(match(new Criteria().andOperator(andList.toArray(new Criteria[andList.size()]))));
ProjectionOperation projection = project("_id", "label",  "code").and("$subWarrantyCategories.label").as("labelSCat").and("$subWarrantyCategories._id").as("CodeSCat");
stages.add(projection);
newAggregation(stages)