/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 vote202 views1 answer
Minimal requirements.txt django
Python Django
0 vote190 views1 answer
How to send file in django response
Python Django
4 votes225 views2 answers
Authentication views django
Python Django
0 vote190 views1 answer
Proper pagination django template
Python Django
-1 vote197 views2 answers
Django cleanup
Python Django
1 vote197 views1 answer
Django genericforeignkey null
Python Django
0 vote179 views1 answer
Using default as none in django mdoels
Python Django
2 votes189 views1 answer
Django get current date
Python Django
0 vote194 views1 answer
Django form field add attrs
Python Django
1 vote191 views1 answer
Query with condition django
Python Django