/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 vote179 views1 answer
Plural name django
Python Django
1 vote170 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django
1 vote169 views1 answer
Django sites framework
Python Django
0 vote153 views1 answer
Django check if get parameter exists
Python Django
1 vote172 views1 answer
How to redirect to another page in django after login
Python Django
1 vote165 views1 answer
User matching query does not exist. django
Python Django
1 vote168 views1 answer
Pip install django celery results
Python Django
0 vote197 views1 answer
Substring in a django template?
Python Django
1 vote163 views1 answer
Django filter text first character upper case
Python Django
0 vote172 views1 answer
Extends template django
Python Django