/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

1 vote255 views1 answer
How to send json in django response
Python Django
1 vote245 views1 answer
Cookies in django
Python Django
0 vote265 views1 answer
Django populate database in view
Python Django
0 vote248 views1 answer
Django raise 404
Python Django
6 votes345 views4 answers
Media django
Python Django
1 vote260 views1 answer
Get csrf_token value in django template
Python Django
-1 vote234 views2 answers
Django view
Python Django
1 vote237 views2 answers
Django in conda
Python Django
0 vote258 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python Django
6 votes264 views2 answers
Django read mesage
Python Django