java - Aggregation in spring boot

Question

I have done Aggregaion Like Following:

 Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.project("date").and(dayOfMonth("$date")).as("day"),
                Aggregation.group("$day").count().as("count"),
                Aggregation.project("count").and("day").previousOperation()
        );

        List<AggregationByDay> demo=  mongoTemplate.aggregate(aggregation, "demo", AggregationByDay.class).getMappedResults();
        System.out.println(orders.size());
        return demo;

it returns output like following:

[
    {
        "day": "1",
        "count": 5
    },
    {
        "day": "2",
        "count": 2
    },
    {
        "day": "3",
        "count": 2
    },
    {
        "day": "4",
        "count": 1
    }
]

But I Want to fetch it's month and year also. My Expected result is following:

[
    {
        "day": "1",
        "count": 5,
        "year": 2021,
        "month": 2
    },
    {
        "day": "2",
        "count": 2,
        "year":2020,
        "month":3
    },
    {
        "day": "3",
        "count": 2,
        "year": 2020,2021,
        "month":4,5
    },
    {
        "day": "4",
        "count": 1,
        "year":"2020"
        "month":9
    }
]

how can i get My expected output using aggregation in spring boot?

question from:https://stackoverflow.com/questions/66062345/aggregation-in-spring-boot

Answer 1

Waitting for answers