/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 vote166 views1 answer
How to customize simplejwt error response message in django restframework
Python Django
0 vote177 views1 answer
Merge two Querysets in Python Django while preserving Queryset methods
Python Django
-1 vote165 views3 answers
Raw sql query to django converter
Python Django
1 vote177 views1 answer
Passing user instance django form submission
Python Django
0 vote176 views1 answer
Extends template django
Python Django
0 vote212 views1 answer
Django admin.py all fields
Python Django
2 votes183 views2 answers
Django regexvalidator example
Python Django
0 vote177 views1 answer
Django update request.post
Python Django
1 vote190 views2 answers
Redirect to the same page django
Python Django
0 vote184 views1 answer
How to populate an image to template in django from views
Python Django