Sunday, November 23, 2014

Re: Using Sum() for a models method inside a Query

related: https://groups.google.com/forum/#!topic/django-users/s9qgXC4TNrA

Short answer: you can't. A raw query would be your best bet(i.e. "SELECT SUM(a + b) AS sum FROM app_X")


On Sunday, November 23, 2014 4:42:48 PM UTC-6, Jorge Andrés Vergara Ebratt wrote:
Hello everyone,

Well, the tittle says it all:

I have a model X

class X(models.Model)
    a = models.IntegerField()
    b = models.IntegerField()

def getC(self):
    return a + b


So, when I'm inside a template I can call {{x.getC}} and it gets the method for the current instance it's in, but how can I get the Sum, or Avg of that method? I tried doing Sum('getC') but I get the error because getC isn't callable in the query...

Thanks in advance for the help

--
Jorge Andres Vergara Ebratt
#SoftwareDeveloper (Or at least trying to be)
@javebratt

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b5350447-264f-4145-be9d-8ea709673918%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment