/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 vote277 views1 answer
Django import settings variables
Python Django
1 vote288 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django
1 vote269 views1 answer
Difference between get and filter in django
Python Django
1 vote260 views1 answer
Filter with different operator in django
Python Django
0 vote249 views1 answer
What is NoReverseMatch in django?
Python Django
0 vote252 views1 answer
Django model registration
Python Django
0 vote312 views1 answer
Code suggestion html not working in django-html
Python Django
2 votes280 views1 answer
Pass in queryset as filter django
Python Django
0 vote277 views2 answers
Django render template
Python Django
1 vote268 views1 answer
How to check the django version on a mac
Python Django