具有 $and、$in 和 $eq 条件的 Spring mongo 聚合过滤器

本文介绍了具有 $and、$in 和 $eq 条件的 Spring mongo 聚合过滤器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 { "Field1": "ABC", "Field2": [ { "Field3": "ABC1","Field4": "REVIEWED","Field5":"True" }, { "Field3": "ABC2","Field4": "APPROVED","Field5":"True" }, { "Field3": "ABC3","Field4": "REJECTED","Field5":"True" }, { "Field3": "ABC4","Field4": "APPROVED","Field5":"False" } ] }

我想获取 APPROVED、REVIEWED 和 True 记录，即.

I want to fetch APPROVED,REVIEWED and True record ie.

{ "Field1": "ABC", "Field2": [ { "Field3": "ABC1","Field4": "REVIEWED","Field5":"True" }, { "Field3": "ABC2","Field4": "APPROVED","Field5":"True" } ] }

以下 mongo 聚合查询返回正确的结果

following mongo aggregation query returns proper result

{ "$project": { "Field1": "$Field1", "Field2": { "$filter": { "input": "$field2", "as": "fld2", "cond": { "$and": [ { "$in": [ "$$fld2.field4", [ "APPROVED", "REVIEWED" ] ] }, { "$eq": [ "$$fld2.field5", "True" ] } ] } } } } }

如何在spring mongo data db中实现上述查询?带有 ArrayOperators.Filter.filter 的 Spring ProjectOperation 不提供链接操作以执行 和 与另一个条件.

how to achieve the above query in spring mongo data db? Spring ProjectOperation with ArrayOperators.Filter.filter not providing chaining operation to do and with another condition.

推荐答案

你可以试试这样使用BasicDBObject

You can try using BasicDBObject like this

BasicDBObject inOp = new BasicDBObject("$in", Arrays.<Object>asList( "$$fld2.field4", Arrays.asList("APPROVED","REVIEWED"))); BasicDBObject eqOp = new BasicDBObject("$eq", Arrays.<Object>asList( "$$fld2.field5", "True")); BasicDBObject andOp = new BasicDBObject("$and", Arrays.<Object>asList(inOp, eqOp)); project("Field1") .and(new AggregationExpression() { @Override public DBObject toDbObject(AggregationOperationContext aggregationOperationContext) { DBObject filterExpression = new BasicDBObject(); filterExpression.put("input","$field2"); filterExpression.put("as", "fld2"); filterExpression.put("cond",andOp); return new BasicDBObject("$filter", filterExpression); } }).as("Field2");