/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 vote163 views1 answer
Django create object from dict
Python Django
0 vote114 views1 answer
Django cleanup settings
Python Django
1 vote132 views2 answers
No changes detected in app django
Python Django
2 votes294 views2 answers
Python django query
Python Django
0 vote115 views10 answers
EMAIL_BACKEND = 'django.core.mail.backends.console.EmailBackend'
Python Django
0 vote127 views1 answer
Django app directory
Python Django
0 vote125 views1 answer
How to add value in array django
Python Django
7 votes135 views5 answers
Django messages
Python Django
31 votes241 views6 answers
Django admin create superuser
Python Django
0 vote150 views2 answers
Extract email address using expression in django
Python Django