Django ORM, sum of multiple columns

Question

I have a question about how we can filter by SUM of multiple columns.

Example:

class Foo(models.Model):
    i1 = models.IntegerField()
    i2 = models.IntegerField()
    i3 = models.IntegerField()

And I need to filter objects where SUM of i1, i2, i3 is less then 200. I've tried achive it with:

Foo.objects.agregate(i_sum=Sum(i1,i2,i3)).filter(i_sum__lt=200) # error
Foo.objects.agregate(i_sum=Sum([i1,i2,i3])).filter(i_sum__lt=200) # error

Thanks.

Wilfried · Accepted Answer · 2017-04-10 13:15:30Z

14

You can use F(), and with annotation:

Foo.objects.annotate(i_sum=F('i1') + F('i2')+ F('i3')).filter(i_sum=200)

answered Apr 10, 2017 at 13:04

Wilfried

1,6331 gold badge12 silver badges19 bronze badges

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

2 Comments

thanks, it was really obvious. Sum is some kind of vertical operation but I needed horizontal.

Glad to help you

itzMEonTV · Accepted Answer · 2017-04-10 13:10:20Z

0

You can use extra

Foo.objects.extra(where=["i1 + i2 + i3 > 200"])

answered Apr 10, 2017 at 13:10

itzMEonTV

20.4k4 gold badges44 silver badges53 bronze badges