/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 vote211 views1 answer
Django-filter field name greater than
Python Django
-2 votes219 views4 answers
Django datepicker
Python Django
0 vote236 views1 answer
Fix the debug_mode = false django
Python Django
6 votes201 views3 answers
Django filter install
Python Django
0 vote267 views1 answer
Django order by foreign key count
Python Django
7 votes230 views3 answers
How to delete migrations in django
Python Django
1 vote231 views2 answers
Django print query
Python Django
0 vote203 views1 answer
Render django views
Python Django
0 vote240 views1 answer
Unsupported media type django
Python Django
2 votes227 views3 answers
Django queryset to list
Python Django