How to use "$dateToString" in Mongo criteriaQuery (Spring Boot)

Question

i use SpringBoot(v1.5.10),SpringData and MongoDb;

db.login.aggregate(
[
    { 
        "$match" : {
            "user._id" : NumberLong(204)
        }
    }, 
    { 
        "$group" : {
            "_id" : {
               "datetime" : { $dateToString: { format: "%d-%m-%Y", date: "$datetime"}}, 
                "ip" : "$ip",


            },
             count: { $sum: 1 }   
        }
    }

]);

2011-01-10 count 5

2011-01-16 count 16

    Criteria criteria = Criteria.where("user._id").is(paramuserid).andOperator(
        Criteria.where("datetime").gte(paramfirstdate),
        Criteria.where("datetime").lt(paramseconddate)
                );
AggregationOperation match = Aggregation.match(criteria);   

List<AggregationOperation> aggregationoperations = new ArrayList <AggregationOperation>();  
aggregationoperations.add(match);
aggregationoperations.add(Aggregation.group("datetime"));  
AggregationResults<?> aggregationresults = this.mngT.aggregate(Aggregation.newAggregation(aggregationoperations), Login.class, Object.class);

2011-01-10 09:00:01 count 1
2011-01-10 09:15:00 count 1

Mongo aggregate group datetime without "time" , I try similar criteriaquery not working because group with time part. How to use "$dateToString" in criteriaquery

Fatih Can · Accepted Answer · 2018-05-29 05:56:18Z

3

I solved.

Criteria criteria = Criteria.where("user._id").is(paramuserid).andOperator(
            Criteria.where("datetime").gte(paramfirstdate),
            Criteria.where("datetime").lt(paramseconddate)
                    );
    AggregationOperation match = Aggregation.match(criteria);   

    List<AggregationOperation> aggregationoperations = new ArrayList <AggregationOperation>();  
    aggregationoperations.add(match);
    aggregationoperations.add(Aggregation.project("ip","datetime").andExpression("datetime").dateAsFormattedString("%d-%m-%Y").as("formateddate"));
    aggregationoperations.add(Aggregation.group("ip","formateddate").count().as("TOT"));
    AggregationResults<?> aggregationresults = this.mngT.aggregate(Aggregation.newAggregation(aggregationoperations), Login.class, Object.class);

edited May 29, 2018 at 5:56

answered May 28, 2018 at 14:04

Fatih Can

311 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

How to use "$dateToString" in Mongo criteriaQuery (Spring Boot)

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