/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 vote313 views1 answer
Shared a local host django
Python Django
0 vote211 views1 answer
Django select_related multiple
Python Django
0 vote243 views1 answer
Django cleanup settings
Python Django
0 vote198 views2 answers
Operator in django query
Python Django
4 votes253 views4 answers
Filter django or
Python Django
0 vote235 views1 answer
Delete history django simple
Python Django
0 vote243 views1 answer
Django today date in template
Python Django
0 vote251 views2 answers
Set environment variable heroku django
Python Django
-1 vote222 views1 answer
Binascii.Error: Incorrect padding in python django
Python Django
0 vote254 views1 answer
Foreignkey as users from a user group django
Python Django