Breaking News: Grepper is joining You.com. Read the official announcement!

how to perform group by with django orm

Add Answer

Anies answered on June 3, 2020 Popularity 10/10 Helpfulness 2/10

answer how to perform group by with django orm

related django group by

related django queryset group by

how to perform group by with django orm

Comment

Transaction.objects.all().values('actor').annotate(total=Count('actor')).order_by('total')
Transaction.objects.all().values('actor').annotate(total=Count('id')).order_by('total')

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: django-orm group-by python

Link to this answer
Share Copy Link

Contributed on Jul 14 2022

Anies

0 Answers Avg Quality 2/10

Closely Related Answers

django group by

Comment

# 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}]

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: django dj

Link to this answer
Share Copy Link

Contributed on Jun 03 2020

Repulsive Raven

0 Answers Avg Quality 2/10

django queryset group by

Comment

from django.db.models import Avg
teams = Analysts.objects.values('class').annotate(avgcap=Avg('gpa'))
# Assuming Analysts model has class and gpa field..
# This will group by class field and give the avg of gpa field values

Popularity 10/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: django-queryset

Link to this answer
Share Copy Link

Contributed on Nov 18 2021

Trained Tuna

0 Answers Avg Quality 2/10

how to perform group by with django orm

Contents

More Related Answers

how to perform group by with django orm

Closely Related Answers

django group by

django queryset group by

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.