/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

0 vote183 views1 answer
Date format django template filter
Python Django
1 vote184 views1 answer
Auto-created primary key used when not defining a primary key type, by default 'django.db.models.AutoField'.
Python Django
0 vote207 views1 answer
Rebuild database from zero django postgres
Python Django
1 vote197 views1 answer
Query with condition django
Python Django
0 vote215 views1 answer
Else if in django template
Python Django
0 vote188 views1 answer
Django versatileimagefield
Python Django
1 vote184 views1 answer
How to redirect to previous page in django
Python Django
4 votes175 views1 answer
Django objects.create()
Python Django
2 votes220 views2 answers
Django template array index
Python Django
-4 votes261 views4 answers
Latest version of django
Python Django