Hi,
I'm trying to create a query like this with django:
SELECT count(*) As total FROM `disposal` group by(salesman_id)
This gives me the number of total sales for every salesman.
In django I tried this:
data = Disposal.objects.annotate(total=Count('salesman'))
print str(x[0].total)
But total is always 1.
Thanks a lot for your help!
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.