How to add Array of Fields to ProjectionOperation with Spring data mongodb

Question

I have this parto of query in mongo that return an array of fields.

{ $project:
    {
        ...
        result:
            [
                { sumShotsOfOneAttempted: '$sumShotsOfOneAttempted1', sumShotsOfOneFailed: '$sumShotsOfOneFailed1'},
                { sumShotsOfOneAttempted: '$sumShotsOfOneAttempted2', sumShotsOfOneFailed: '$sumShotsOfOneFailed2'}
            ]

    }
}

I'm trying to build the same with spring-mongodb using ProjectionOperation:

ProjectionOperation projectStage = Aggregation.project("fieldId");

And I want to add the fields inside of array to this projectStage, but I only know how to add one by one as projectStage.and("sumShotsOfOneAttempted1").as(sumShotsOfOneAttempted); but not arrays.

My depndendencies of spring.mongodb:

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

Any idea please?

charlycou · Accepted Answer · 2019-02-20 14:55:01Z

1

As mentioned in you other post enter link description here

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:55

charlycou

2,05519 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

How to add Array of Fields to ProjectionOperation with Spring data mongodb

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