/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 vote251 views1 answer
Django.db.backends.mysql install
Python Django
0 vote211 views1 answer
Django add queury parameters to reverse
Python Django
0 vote375 views1 answer
Django form custom validation
Python Django
9 votes206 views1 answer
Delete object from table django
Python Django
0 vote260 views1 answer
Example of django template for forms
Python Django
0 vote222 views1 answer
Request.body django
Python Django
6 votes226 views3 answers
Media url django
Python Django
0 vote242 views1 answer
Django auto increment field
Python Django
0 vote205 views1 answer
Django get latest object
Python Django
0 vote213 views1 answer
Pass context data with templateview in django
Python Django