/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 vote149 views1 answer
Image delete in django from the folder
Python Django
0 vote102 views1 answer
Django rest framework multiple user registration
Python Django
0 vote152 views1 answer
Aes in django
Python Django
0 vote173 views2 answers
Blog in django
Python Django
0 vote155 views1 answer
Listing of django model types
Python Django
1 vote145 views1 answer
How to filter queryset with foreign key in django
Python Django
4 votes174 views1 answer
Python django shell command
Python Django
1 vote166 views1 answer
Get csrf_token value in django template
Python Django
0 vote154 views1 answer
Make value of two tables unique django
Python Django
0 vote147 views2 answers
Django ajax body to json
Python Django