/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 vote162 views1 answer
Django queryset group by sum
Python Django
1 vote139 views1 answer
Django loop index
Python Django
0 vote166 views1 answer
Django customize the user model
Python Django
4 votes165 views2 answers
ImportError: No module named django.core.wsgi
Python Django
0 vote157 views1 answer
Django queryset to instance
Python Django
3 votes166 views1 answer
Django import model from another app
Python Django
1 vote153 views2 answers
Check db calls django
Python Django
0 vote160 views1 answer
Django created at field
Python Django
1 vote161 views1 answer
Using regex validators in django models
Python Django
0 vote186 views1 answer
Substring in a django template?
Python Django