/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 vote215 views1 answer
Unsupported media type django
Python Django
1 vote163 views2 answers
How to get user id django
Python Django
0 vote174 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python Django
1 vote163 views1 answer
Django createmany
Python Django
0 vote166 views1 answer
Create and add many to many field in django
Python Django
0 vote154 views1 answer
Function of this cod in django in django performance = serializers.SerializerMethodField() # def get_performance(self, instance): # return PerformanceSerializer(instance.performance).data
Python Django
0 vote211 views4 answers
"%(class)s" in django
Python Django
0 vote165 views1 answer
How to instal django cities
Python Django
0 vote172 views1 answer
Using default as none in django mdoels
Python Django
13 votes194 views6 answers
Django orm
Python Django