Django queryset group by

Django group by

# If you mean to do aggregation you can use the aggregation features of the ORM:
from django.db.models import Count
Members.objects.values('designation').annotate(dcount=Count('designation'))

# This results in a query similar to:
SELECT designation, COUNT(designation) AS dcount
FROM members GROUP BY designation

#and the output would be of the form
[{'designation': 'Salesman', 'dcount': 2}, 
 {'designation': 'Manager', 'dcount': 2}]

Source: stackoverflow.com

Similar codes

0 vote168 views2 answers
Render template in django
Python Django
2 votes190 views2 answers
Count gabarit django
Python Django
0 vote198 views2 answers
Blog in django
Python Django
0 vote186 views1 answer
Get date only from datetimefiel django
Python Django
0 vote180 views2 answers
Django pagination class based views
Python Django
0 vote185 views1 answer
Django import Response
Python Django
-1 vote178 views1 answer
Class views django slug
Python Django
0 vote177 views1 answer
Django raise 404
Python Django
0 vote153 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 vote176 views1 answer
How to order randomly in django orm
Python Django