Annotate and Aggregate function in django

Posted by thesteve on Stack Overflow See other posts from Stack Overflow or by thesteve
Published on 2011-03-02T23:22:53Z Indexed on 2011/03/02 23:24 UTC
Read the original article Hit count: 391

In django I have the following tables and am trying to count the number of votes by item.

class Votes(models.Model):
    user = models.ForeignKey(User)
    item = models.ForeignKey(Item)


class Item(models.Model):
    name = models.CharField()
    description = models.TextField()

I have the following queryset

queryset = Votes.objects.values('item__name').annotate(Count('item'))

that returns a list with item name and view count but not the item object. How can I set it up so that the object is returned instead of just the string value? I have been messing around with Manager and Queryset methods, that the right track? Any advice would be appreciated.

© Stack Overflow or respective owner

Related posts about django-models

Related posts about django-queryset