/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 vote239 views1 answer
Django class based views ListView
Python Django
1 vote246 views2 answers
Django queryset unique values
Python Django
0 vote195 views1 answer
Django model manager user
Python Django
0 vote231 views2 answers
Extract email address using expression in django
Python Django
0 vote206 views1 answer
Django.db.backends.mysql install
Python Django
0 vote209 views1 answer
Django http response 204
Python Django
0 vote237 views2 answers
How to get current page url in django template
Python Django
1 vote229 views2 answers
No changes detected in app django
Python Django
13 votes240 views2 answers
Delete database entry using name django
Python Django
22 votes227 views6 answers
How to check django version
Python Django