How to use MongoTemplate cond and filter in java code?

Question

How to use in springframework_data_mongodb like image?

enter image description here

Answer 1

This is an example from MongoDB manual for $filter aggregation converted to Spring Data MongoDB code. The same syntax can be applied to the question about using the $filter along with a condition.

MongoOperations mongoOps = new MongoTemplate(MongoClients.create(), "test");
Aggregation agg = newAggregation(
                      project()
                         .and(filter("items")
                              .as("item")
                              .by(Gte.valueOf("item.price").greaterThanEqualToValue(100)))
                         .as("items")
);
        
AggregationResults<Document> results = mongoOps.aggregate(agg, "sales", Document.class);        
results.forEach(doc -> System.out.println(doc.toJson()));

Reference: org.springframework.data.mongodb.core.aggregation.ArrayOperators.Filter.

Answer 2

Here is the code specific to your problem if you use Java 8 and Spring Data MongoDB 3.0.3.RELEASE.

import static org.springframework.data.mongodb.core.aggregation.Aggregation.match;
import static org.springframework.data.mongodb.core.aggregation.Aggregation.project;
import static org.springframework.data.mongodb.core.aggregation.ArrayOperators.Filter.filter;
import static org.springframework.data.mongodb.core.query.Criteria.where;

MongoOperations mongoOps = new MongoTemplate(MongoClients.create(), "database");
ProjectionOperation projectionOperation =  project().and(filter("fields")
                 .as("field")
                 .by(Eq.valueOf("field.code").equalToValue("EngName")))
                 .as("fields");
MatchOperation matchOperation = match(where("fields.value").in("A","B"));
Aggregation agg = Aggregation.newAggregation(projectionOperation,matchOperation);
AggregationResults<Document> docs = mongoOps.aggregate(agg, "collection", Document.class);
        
docs.forEach(doc->System.out.println(doc));