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 vote330 views1 answer
Credential not provided when i try to sign up a new user django
Python Django
0 vote317 views1 answer
Include app in django project
Python Django
0 vote296 views1 answer
Djangodebug toolbar not showing
Python Django
0 vote285 views2 answers
Django pagination class based views
Python Django
0 vote273 views1 answer
Django capture the file upload
Python Django
0 vote225 views1 answer
Django set boolean field value in view
Python Django
0 vote294 views1 answer
Get date only from datetimefiel django
Python Django
1 vote260 views1 answer
Django change value and save model object
Python Django
17 votes302 views6 answers
Django model
Python Django
0 vote290 views1 answer
Re_path(r'^logout/$',views.logout, {"next_page":'/'},name="logout"), AttributeError: module 'django.contrib.auth.views' has no attribute 'logout'
Python Django