/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 vote212 views3 answers
How to create a User and User profile in django rest framework
Python Django
10 votes184 views2 answers
Django import settings
Python Django
4 votes226 views4 answers
How to change django admin text
Python Django
0 vote178 views1 answer
Reading json without using relative path in django
Python Django
0 vote200 views1 answer
Django create multiple objects
Python Django
1 vote210 views2 answers
How to access cookies in django
Python Django
0 vote183 views1 answer
Abstract user in django
Python Django
0 vote186 views1 answer
How i dynamically populate to CORS_ALLOWED_ORIGINS in django rest framework
Python Django
0 vote210 views1 answer
Django 3.2 compatible to python 3.10?
Python Django
0 vote189 views2 answers
Django pagination class based views
Python Django