Spring data mongodb aggregation with Java list

Question

I am new to using mongo aggregate query, where in the below query I use projectIdList and group totalCount & totalAmount. How can I get the individual projectId long with its totalCount and totalAmount.

Aggregation aggregate = newAggregation(
                match(Criteria.where("projectId").in(projectIdList)
               .and("‌isAvailable").in(false)
               .and(status).in("rejected")
               .and(updatedTime).gt().lt()),
                group("projectId").count().as("totalCount")
              .sum(ConvertOperators.Convert.convertValueOf("amount").to("decimal").as("totalAmount"));

Please suggest.

Vini · Accepted Answer · 2022-12-15 19:48:53Z

You can use the group aggregation stage to get both the amount and the count. Here is a sample of how I tried:

    Criteria matchCriteria = Criteria.where("projectId").in(projectIdList)
            .and("isAvailable").is(false)
            .and("status").is("rejected");

    // Match stage
    MatchOperation matchStage = Aggregation.match(matchCriteria);
    
    // Group Operation 
    GroupOperation group = group("projectId")
                                    .sum("amount").as("totalAmount") // sum 
                                    .count().as("count");                       // count
    // Aggregation
    Aggregation aggregation = newAggregation(matchStage, group);

    AggregationResults<Project> result = mongoTemplate.aggregate(aggregation, "projects", Project.class);

Result has both count and totalAmount:

[
  {_id=1001, totalAmount=4000.0, count=4}, 
  {_id=1002, totalAmount=4000.0, count=2}, 
  {_id=1003, totalAmount=3000.0, count=1}}
]

Collectives™ on Stack Overflow

Spring data mongodb aggregation with Java list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related