/Python/Django/Django orm group by month and year

Django orm group by month and year

print([v for v in
       Request.objects.annotate(month=ExtractMonth('date_creation'),
                                year=ExtractYear('date_creation'),)
                      .order_by()
                      .values('month', 'year')
                      .annotate(total=Count('*'))
                      .values('month', 'year', 'total')
       ])

Source: stackoverflow.com

Similar codes

0 vote277 views1 answer
Make value of two tables unique django
Python Django
0 vote257 views1 answer
Merge two query sets django
Python Django
1 vote308 views1 answer
How to multiply in django template
Python Django
1 vote287 views1 answer
Delete and start fresh with db django
Python Django
0 vote297 views2 answers
Render template in django
Python Django
5 votes288 views2 answers
Django password field
Python Django
0 vote277 views2 answers
MultiValueDictKeyError django
Python Django
1 vote286 views1 answer
Django createmany
Python Django
0 vote287 views1 answer
Django route accept params with character
Python Django
1 vote280 views2 answers
Check db calls django
Python Django