/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 vote306 views1 answer
Customise the django rest api view
Python Django
0 vote308 views1 answer
Initial TypedMultipleChoiceField django
Python Django
2 votes268 views1 answer
Postgres django settings
Python Django
0 vote308 views1 answer
Django test imagefield
Python Django
0 vote295 views1 answer
Create jwt token in django
Python Django
7 votes287 views2 answers
How to generate requirements.txt django
Python Django
1 vote299 views1 answer
Add background image in django uploaded file
Python Django
5 votes306 views1 answer
How to override save method in django
Python Django
0 vote296 views2 answers
Django get superuser password
Python Django
4 votes294 views2 answers
Authentication views django
Python Django