django get sum of column based on where clause

Question

I have read the documentation related to django aggregation but I am still have trouble figuring out how exactly I can get a sum of points per user.

Here is what I tried:

ModelName.objects.filter(username=rUser.username).aggregate(Sum('points'))

I get the following error:

Request Method: GET
Request URL:    http://localhost:8001/mypage/
Django Version: 1.4.8
Exception Type: NameError
Exception Value:    
global name 'Sum' is not defined

alecxe · Accepted Answer · 2014-04-09 16:34:44Z

12

You need to import Sum first:

from django.db.models import Sum

answered Apr 9, 2014 at 16:34

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

django get sum of column based on where clause

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related