/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 vote149 views1 answer
How to add phone number to django user model
Python Django
1 vote148 views2 answers
Django client ip
Python Django
-2 votes146 views4 answers
Django datepicker
Python Django
8 votes169 views3 answers
Django sort queryset
Python Django
5 votes159 views2 answers
Django form password field
Python Django
0 vote149 views1 answer
AttributeError: module 'django.db.models' has no attribute 'ArrayField'
Python Django
2 votes157 views2 answers
How to get only first record in django
Python Django
0 vote180 views1 answer
Django model make the field caseinsensitive
Python Django
1 vote159 views1 answer
Db_index django
Python Django
1 vote159 views1 answer
Select realted for foreign key table in django
Python Django