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 vote261 views1 answer
How to get a mock image in django?
Python Django
1 vote220 views2 answers
Django class based views
Python Django
0 vote245 views1 answer
Django sesssion can't works when web app call inside an iframe from other website
Python Django
0 vote231 views1 answer
Django array of dates
Python Django
0 vote236 views1 answer
Extends template django
Python Django
0 vote252 views1 answer
Django not detecting new model
Python Django
0 vote283 views2 answers
Django template in views.py
Python Django
0 vote234 views1 answer
Ssl django nginx
Python Django
0 vote286 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python Django
0 vote265 views1 answer
Redirect if not logged in django
Python Django