How to count and display objects in relation ManyToMany in Django

Question

I have a simple model with news and categories:

class Category(models.Model):
    name = models.CharField()
    slug = models.SlugField()

class News(models.Model):
    category = models.ManyToManyField(Category)
    title = models.CharField()
    slug = models.SlugField()
    text = models.TextField()
    date = models.DateTimeField()

I want to count news for each category and display it on the website, like this:

Sport (5)
School (4)
Films (6)
Computer (2)
etc...

How can I do this??

Thanks!

Vitaly · Accepted Answer · 2009-11-20 22:03:22Z

7

Check out annotate() function from Django 1.1.

http://docs.djangoproject.com/en/dev/topics/db/aggregation/#topics-db-aggregation

Example (from that URL above):

>>> q = Book.objects.annotate(num_authors=Count('authors'))
>>> q[0].num_authors
2
>>> q[1].num_authors
1

answered Nov 20, 2009 at 22:03

Vitaly

2,5855 gold badges29 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Matthew Over a year ago

I tried this, but i got AttributeError: 'Manager' object has no attribute 'annotate'

Dmitry Risenberg Over a year ago

Category.objects.all().annotate(num_news = Count('news_set'))

user1882644 · Accepted Answer · 2013-08-29 15:44:10Z

1

Very simple:

>>> for category in Category.objects.all():
...     print category.name, category.news_set.count()

answered Aug 29, 2013 at 15:44

user1882644

Collectives™ on Stack Overflow

How to count and display objects in relation ManyToMany in Django

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related