How to use like $dateToString in Aggregation $group for Spring Data Mongo

Asked Dec 26 '19 at 02:00

Active Dec 26 '19 at 14:24

Viewed 798 times

I need to implement aggregation in Spring-Data MongoDB.

This aggregation $group works successfully in Mongo Compass:

$group{
  {
    _id:  { $dateToString: { format: "%Y-%m-%d", date: "$date" }},
    doc: {"$push":"$$ROOT"}

  }
}

This is the result expected group by year month and day and push results with all field in array docs

I try to implement this aggregation Spring Mongo:

My problem is that lose data and only get a date by the previous projection.

I prefer not use the $project and only $group stage.

edited Dec 26 '19 at 14:24

Valijon

asked Dec 26 '19 at 02:00

Spring Data MongoDB doesn't support group operation on AggregationExpression. So you have to use projection pipeline before the group stage. – Ashish Bakwad Dec 26 '19 at 12:01
You may implement custom AggregationOperation explained [here](https://stackoverflow.com/a/39405880/3710490) and use same `$group` pipeline stage instead of `$project` – Valijon Dec 26 '19 at 14:26
thanks for reply works $project – William Andrés Rodríguez Borja Dec 27 '19 at 14:47
But your choice is exactly what I wanted to do. I wanted to be able to use pure mongo queries because I have complex queries thanks valijon – William Andrés Rodríguez Borja Dec 27 '19 at 15:48

0 Answers0