/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 vote343 views1 answer
Django retrieveupdatedestroyapiview
Python Django
4 votes373 views3 answers
ArrayField in Django
Python Django
0 vote354 views1 answer
Django.db.utils.ProgrammingError: can't adapt type 'dict_keys'
Python Django
1 vote403 views1 answer
Hide particular attribute in django admin
Python Django
0 vote342 views1 answer
Django model meta ordering multiple ordering
Python Django
1 vote394 views4 answers
Join tables in django orm
Python Django
25 votes504 views2 answers
Start new app in django
Python Django
0 vote395 views1 answer
How to form .cleaned data in class based views in django
Python Django
0 vote306 views1 answer
Django set boolean field value in view
Python Django
0 vote378 views1 answer
Django.com
Python Django