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

1 vote288 views1 answer
Django get id of newly created object
Python Django
0 vote349 views1 answer
Django database connection isn't set to UTC postgresql
Python Django
0 vote295 views3 answers
Django add user to group
Python Django
0 vote296 views1 answer
Register template tag django
Python Django
3 votes315 views1 answer
Business logic in django
Python Django
6 votes288 views5 answers
How to redirect in django
Python Django
1 vote313 views1 answer
Object.image.url email template django
Python Django
0 vote294 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 vote278 views1 answer
Onetoone vs foreign key django
Python Django
2 votes305 views1 answer
Favicon django
Python Django