How to write MongoDb Aggregation for this Criteria query

Question

This is Criteria Query

Query query = new Query();
        query.addCriteria(Criteria.where("careGiverId").is(careTakerId));
        query.addCriteria(Criteria.where("careType").is(careType));         
        return mongoOperations.count(query,  CareLogBean.class);

How to apply Mongodb Aggregations on this...i will return count ....help me thanks in advance

Can you explain what is the problem with current query ? Why do you need aggregation ? — s7vr, Mar 31 '17 at 13:36
No problem... but while performance wise i want to use Aggregations. will it is possible to return count in aggregation ? — Vara Prasad, Apr 03 '17 at 05:17

score 0 · Accepted Answer · answered Apr 03 '17 at 14:20

You can try something like below for Mongo Server 3.4 version with Spring Mongo 1.10.1.Release. Uses $count aggregation operator.

 AggregationOperation match = Aggregation.match(Criteria.where("careGiverId").is(careTakerId).and("careType").is(careType));
 AggregationOperation count = Aggregation.count().as("count");
 Aggregation agg = Aggregation.newAggregation(match, count);
 mongoOperations.aggregate(agg, CareLogBean.class);

How to write MongoDb Aggregation for this Criteria query

1 Answers1

Linked