How build Spring Data Mongo Aggregation Operations using for-loop

Question

The following example works perfectly.

    MatchOperation matchStage = mongodbConstructorQueryUtils.makeMatchStage(topCriteria);

        GroupOperation groupStage = Aggregation.group("teamId", "teamName")
            .sum("shotsOfOneAttempted").as("sumShotsOfOneAttempted")
            .sum("shotsOfTwoAttempted").as("sumShotsOfTwoAttempted")
            .sum("shotsOfThreeAttempted").as("sumShotsOfThreeAttempted")
            .addToSet("idMatchCallExt").as("matches");

        ProjectionOperation projectionOperation = Aggregation.project("matches")
            .and("sumShotsOfOneAttempted").as("sumShotsOfOneAttempted")
            .and("sumShotsOfTwoAttempted").as("sumShotsOfTwoAttempted")
            .and("sumShotsOfThreeAttempted").as("sumShotsOfThreeAttempted")
            .and("matches").size().as("sumMatches");

        Aggregation agg = Aggregation.newAggregation(
                matchStage,
                groupStage,
                projectionOperation
        );

Example with for-loops:

    MatchOperation matchStage = mongodbConstructorQueryUtils.makeMatchStage(topCriteria);

    GroupOperation groupStage = Aggregation.group("teamId", "teamName");
    for(String typeOfShots : typesOfShots) {
        groupStage.sum(typeOfShots+"Attempted").as("sum"+typeOfShots+"Attempted");
    }
    groupStage.addToSet("idMatchCallExt").as("matches");

    ProjectionOperation projectionOperation = Aggregation.project("matches");

    for(String typeOfShots : typesOfShots) {
        projectionOperation.and("sum"+typeOfShots+"Attempted").as("sum"+typeOfShots+"Attempted");
    }

    Aggregation agg = Aggregation.newAggregation(
            matchStage,
            groupStage,
            projectionOperation
    );

It doesn't work. It just build groupStage with teamId and teamName, and projectionOperation failds to found matches and so on...

My depndendencies of spring.mongodb:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>

Do you know why it doesn't work?

Attempted should be "Attempted", am I wrong?

charlycou
– charlycou

2019-02-20 09:00:31 +00:00
Commented Feb 20, 2019 at 9:00 — charlycou
– charlycou, Commented Feb 20, 2019 at 9:00
Yes, I'm gonna edit the question. Thx.

vlarios
– vlarios

2019-02-20 11:26:05 +00:00
Commented Feb 20, 2019 at 11:26 — vlarios
– vlarios, Commented Feb 20, 2019 at 11:26

charlycou · Accepted Answer · 2019-02-20 14:47:52Z

1

You have the same problem for both project and group operation. I'll take the porject operation as an example.

Your method projectionOperation.and("sum"+typeOfShots+"Attempted").as("sum"+typeOfShots+"Attempted"); will return a ProjectOperation. But your not saving your result in your variable so only Aggregation.project("matches"); is executed by the aggregation pipeline.

Instead you could try

ProjectionOperation projectionOperation = Aggregation.project("matches");

for(String typeOfShots : typesOfShots) {
    projectionOperation = projectionOperation.and("sum"+typeOfShots+"Attempted").as("sum"+typeOfShots+"Attempted");
}

answered Feb 20, 2019 at 14:47

charlycou

2,05519 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

How build Spring Data Mongo Aggregation Operations using for-loop

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related