/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 vote213 views2 answers
Check db calls django
Python Django
0 vote218 views2 answers
Jsonresponse status code django
Python Django
1 vote261 views3 answers
Value list in django
Python Django
10 votes230 views1 answer
Add static file in django
Python Django
6 votes205 views1 answer
Django model form
Python Django
1 vote228 views1 answer
For loop django template count
Python Django
-1 vote214 views1 answer
Django email verification
Python Django
1 vote253 views2 answers
How to access cookies in django
Python Django
2 votes262 views2 answers
Django queryset is in list
Python Django
9 votes206 views1 answer
Delete object from table django
Python Django