/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 vote218 views1 answer
Django template child data in nested loop
Python Django
2 votes221 views1 answer
Count the number of rows in a database table in Django
Python Django
-1 vote218 views2 answers
How to url encode using python django
Python Django
13 votes234 views2 answers
Delete database entry using name django
Python Django
0 vote139 views1 answer
Get value of variable in session django
Python Django
1 vote246 views2 answers
Django unique_together
Python Django
0 vote369 views1 answer
Django form custom validation
Python Django
14 votes250 views6 answers
Install django
Python Django
3 votes221 views1 answer
ModuleNotFoundError: No module named 'django.core.urlresolvers'
Python Django
1 vote227 views1 answer
Django making a custom 403 page
Python Django