On Nov 28, 8:36 am, Benjamin Wolf <b...@shs-it.de> wrote:
> 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.
>What happens when you run the query outside of Django? You can see the SQL that Django is generating for you by looking at something like db.connection.queries[-1]['sql'], or for more debugging goodness, you can install the Django debug toolbar. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
