/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 vote193 views1 answer
Validate delete inline formset django
Python Django
1 vote167 views1 answer
Django get model class from queryset
Python Django
0 vote183 views1 answer
"DO_NOTHING" is not defined django
Python Django
6 votes233 views4 answers
Media django
Python Django
0 vote192 views2 answers
Generate-thumbnails-in-django-with-pil
Python Django
3 votes191 views2 answers
Update_or_create django
Python Django
1 vote178 views1 answer
Make new app folder in django templates dir
Python Django
2 votes215 views1 answer
How to return total elements in database django
Python Django
0 vote172 views1 answer
Serializing nested objects drf,django restframework nested object serialization
Python Django
1 vote183 views1 answer
Django models.py convert DateTimeField to DateField
Python Django