/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

11 votes166 views2 answers
How to add static files in django
Python Django
2 votes158 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python Django
1 vote199 views1 answer
Django __str__ self multiple
Python Django
0 vote166 views1 answer
How i dynamically populate to CORS_ALLOWED_ORIGINS in django rest framework
Python Django
2 votes174 views2 answers
Django queryset is in list
Python Django
0 vote169 views1 answer
Cannot cast type smallint to boolean django
Python Django
2 votes160 views1 answer
Django queryset get all distinct
Python Django
1 vote198 views1 answer
Keep the user logged in even though user changes password django
Python Django
0 vote176 views1 answer
Django date grater
Python Django
4 votes188 views2 answers
Change django admin title
Python Django