Create filter aggregation in spring

Question

I recently started exploring Aggregation Framework in MongoDB with SpringData. I could Create following query i.e

db.consumer_order.aggregate([
                            { $match: {_id: ObjectId("59e43f542397a00de0c688e4"), "orderState":"Confirmed"}},
                            { $project: {
                                parts: {$filter: {
                                    input: '$parts',
                                    as: 'item',
                                    cond: {$eq: ['$$item.currentState', "Estimation Confirmed"]}
                                }}
                            }}
                        ])

with MongoDB Native Driver in Spring with the following Code

List<Document> aggrigationList = new ArrayList<>();

List<String> conditions = new ArrayList<>();
conditions.add("$$item.currentState");
conditions.add("Estimation Confirmed");

Document matchDoc = new Document("$match",new Document("_id",new ObjectId(orderId)));
Document projectDoc = new Document("$project",new Document("parts",new Document("$filter",new Document("input","$parts").append("as", "item").append("cond", new Document("$eq",conditions)))));
aggrigationList.add(matchDoc);
aggrigationList.add(projectDoc);

Document orderWithPendingParts = consumerOrderCollection.aggregate(aggrigationList).first();

But I do know it's not a good practice to work always with Native Driver since we've Spring-Data in hand. But I'm having trouble to construct the above MongoDB query to AggrigationObject Using Spring Data. I tried with the below, But find difficulty in Constructing Aggregation.project() i.e

mongoTemplate.aggregate(Aggregation.newAggregation(
            Aggregation.match(Criteria.where("owner").is(user).andOperator(Criteria.where("orderState").is("confirmed"))),
            ***Finding Difficulty in here***
            ), inputType, outputType)

Guide me, If I'm doing something wrong.

s7vr · Accepted Answer · 2018-01-19 10:16:10Z

21

You can try below query.

Static Imports

import static org.springframework.data.mongodb.core.aggregation.Aggregation.*;
import static org.springframework.data.mongodb.core.aggregation.ArrayOperators.Filter.filter;
import static org.springframework.data.mongodb.core.aggregation.ComparisonOperators.Eq.valueOf;

Code

Aggregation aggregation = newAggregation(
           project().and(filter("parts")
             .as("item")
             .by(valueOf(
                  "item.currentState")
                   .equalToValue(
                  "Estimation Confirmed")))
          .as("parts");
);

List<outputType> results = mongoTemplate.aggregate(aggregation, inputType, outputType)

edited Jan 19, 2018 at 10:16

answered Oct 16, 2017 at 11:20

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Kishore Kumar Korada Over a year ago

Getting error since project method takes array of strings as parameters like project(String... fields), but you've specified Array Operators as parameters. Or Did I miss something

Kishore Kumar Korada Over a year ago

Thank you. I've tried it. It's working without errors. But when it comes to fetching results it's slightly different, when I'm expecting one document as a result, it's fetching multiple. Are you sure It matches exactly with above query I've mentioned? Because the query I've mentioned is what to be aggregated in spring. Thank you one more time for your patience :)

s7vr Over a year ago

Np. This is the generated query

[ { "$project" : { "parts" : { "$filter" : { "input" : "$parts" , "as" : "item" , "cond" : { "$eq" : [ "$$item.currentState" , "Estimation Confirmed"]}}}}}]

. Are you sure your match is working correctly ?

s7vr Over a year ago

Can you add a document each which is expected and one which is not expected along with your updated query to the post ?

Kishore Kumar Korada Over a year ago

Sure. Sorry for the late. I was on leave.

|

Collectives™ on Stack Overflow

Create filter aggregation in spring

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related