/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 vote207 views1 answer
Django phone number
Python Django
0 vote231 views1 answer
Redirect if not logged in django
Python Django
0 vote200 views1 answer
Django model meta ordering multiple ordering
Python Django
0 vote209 views6 answers
Python django
Python Django
0 vote213 views1 answer
Django update field after save
Python Django
2 votes239 views5 answers
Django documentation
Python Django
2 votes238 views2 answers
Django template array index
Python Django
29 votes371 views3 answers
Django admin create project
Python Django
1 vote155 views1 answer
Django template decimal places
Python Django
1 vote205 views1 answer
Django get id of newly created object
Python Django