/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

1 vote308 views1 answer
Correr servidor django
Python Django
0 vote294 views1 answer
Django is .get lazy
Python Django
0 vote314 views1 answer
Django model specify table name
Python Django
0 vote297 views1 answer
Get list of users django
Python Django
-2 votes315 views6 answers
Django download
Python Django
1 vote300 views1 answer
Number of database queries django
Python Django
0 vote318 views1 answer
Dynamic footer in django
Python Django
2 votes341 views1 answer
Django static media
Python Django
0 vote330 views1 answer
How to run django server outside world
Python Django
4 votes298 views2 answers
Change django admin title
Python Django