/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 vote367 views1 answer
Django sesssion can't works when web app call inside an iframe from other website
Python Django
0 vote352 views1 answer
Connectionrefusederror at /accounts/signup/ django allauth
Python Django
0 vote376 views2 answers
Fetching data from multiple tables using related name in django
Python Django
4 votes272 views1 answer
Django listview
Python Django
0 vote300 views1 answer
Django jwt custom authentication
Python Django
1 vote416 views1 answer
Insert data in django models
Python Django
13 votes400 views6 answers
Django orm
Python Django
1 vote343 views1 answer
Django httpresponseredirect
Python Django
0 vote345 views1 answer
Import "whitenoise.django" could not be resolved
Python Django
1 vote388 views1 answer
Django models.py convert DateTimeField to DateField
Python Django