/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 vote231 views1 answer
Django sign up
Python Django
1 vote243 views1 answer
Django models.py convert DateTimeField to DateField
Python Django
0 vote228 views1 answer
How to form .cleaned data in class based views in django
Python Django
0 vote234 views1 answer
App is not a registered namespace django
Python Django
5 votes221 views2 answers
How to reset username and password in django admin
Python Django
0 vote222 views1 answer
Django app directory
Python Django
0 vote176 views1 answer
Create a queryset list django
Python Django
0 vote241 views1 answer
Start a django project
Python Django
1 vote239 views1 answer
Django datetimefield default
Python Django
23 votes254 views3 answers
Django drf
Python Django