/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 vote365 views2 answers
Django cleanup
Python Django
7 votes377 views4 answers
From django.contrib import messages
Python Django
0 vote385 views1 answer
Django admin required decorator
Python Django
2 votes377 views4 answers
Django login required
Python Django
0 vote396 views1 answer
Extends template django
Python Django
2 votes385 views2 answers
Or in django query
Python Django
0 vote414 views1 answer
How to get a mock image in django?
Python Django
0 vote410 views1 answer
Using claudinary in django
Python Django
0 vote387 views1 answer
How to query json field django
Python Django
0 vote357 views1 answer
Django db_index=true
Python Django