/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 vote313 views1 answer
Django test postgres extensions intarray
Python Django
6 votes319 views2 answers
Kill port django
Python Django
0 vote319 views1 answer
Django queryset last 10
Python Django
0 vote269 views1 answer
Prefetched_related django rest framework
Python Django
0 vote346 views1 answer
Django database connection isn't set to UTC postgresql
Python Django
0 vote302 views1 answer
Cannot cast type smallint to boolean django
Python Django
0 vote282 views1 answer
Django amzon like app
Python Django
1 vote293 views1 answer
For loop in django
Python Django
0 vote301 views1 answer
Django admin no such table user
Python Django
10 votes335 views2 answers
Adding static file and its usage in Django
Python Django