spring mongodb aggregation sum counting

Question

i am new to mongodb with spring boot. What i want is that how can i handle total count.

here is my spring code

Criteria creteria =Criteria.where("name").is("james"));
MatchOperation matchStage = Aggregation.match(creteria);
GroupOperation group = group("userId").count().as("totalCnt");


Aggregation aggregation = Aggregation.newAggregation(matchStage, group );

AggregationResults<Map> list= mongoTemplate.aggregate(aggregation,"listCollection", Map.class);



for(Map map:list){

    System.out.println("list :"+list);
}
===result===
list :{_id=111, totalCnt=1}
list :{_id=222, totalCnt=41}
list :{_id=333, totalCnt=41}

I want to calculate total count:83. How can i fix my code to get sum data. Please give me some hint.

you have applied GroupOperation which return total count based on formed group. if you want total count remove GroupOperation — DHARMENDRA SINGH
– DHARMENDRA SINGH, Commented Jan 24, 2018 at 3:19

Saravana · Accepted Answer · 2018-01-24 03:38:10Z

3

change this

GroupOperation group = group("userId").count().as("totalCnt");

to

CountOperation group = count().as("totalCnt");

edited Jan 24, 2018 at 3:38

answered Jan 24, 2018 at 3:16

Saravana

12.8k2 gold badges42 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

spring mongodb aggregation sum counting

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