/Python/Django/How to count post by category django

How to count post by category django

#views.py
from django.db.models import Count
# You should change post in Count function based on your model.
categories = Category.objects.all().annotate(posts_count=Count('post'))

#Then you will have access to number of posts for each category:
for category in categories:
    print(category.posts_count)

#in your template
{% for category in categories %}
      <p>Number of posts: {{category.posts_count}}</p>
{% endfor %}

Source: stackoverflow.com

Similar codes

10 votes421 views1 answer
Add static file in django
Python Django
1 vote414 views1 answer
Access-Control-Allow-Origin django
Python Django
0 vote321 views1 answer
Django template date format yyyy-mm-dd
Python Django
0 vote351 views3 answers
Django custom authentication
Python Django
0 vote464 views1 answer
AttributeError: 'QuerySet' object has no attribute django
Python Django
0 vote373 views1 answer
Visitor IP address django
Python Django
4 votes378 views3 answers
No such table: django_session
Python Django
0 vote372 views2 answers
Generate-thumbnails-in-django-with-pil
Python Django
0 vote356 views1 answer
Django user refistration
Python Django
0 vote336 views1 answer
Django MESSAGE_TAGS
Python Django