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-10T13:15:30.943

14

You can use F(), and with annotation:

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

edited Apr 10 '17 at 13:15

answered Apr 10 '17 at 13:04

Wilfried

1

thanks, it was really obvious. Sum is some kind of vertical operation but I needed horizontal. – wowbrowser search Apr 10 '17 at 13:08
Glad to help you – Wilfried Apr 10 '17 at 13:15

score 0 · Answer 2 · answered Apr 10 '17 at 13:10

0

You can use extra

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

answered Apr 10 '17 at 13:10

itzMEonTV

2 Answers2