/Python/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 vote140 views1 answer
When button is clicked tkinter python
Python
0 vote184 views1 answer
Re_path(r'^logout/$',views.logout, {"next_page":'/'},name="logout"), AttributeError: module 'django.contrib.auth.views' has no attribute 'logout'
Python Django
1 vote149 views1 answer
Python open new chrome tab
Python
0 vote199 views1 answer
Cannot cast type smallint to boolean django
Python Django
0 vote166 views1 answer
Pandas to csv encoding
Python
4 votes181 views1 answer
Django objects.create()
Python Django
-1 vote166 views1 answer
Global list python
Python
2 votes154 views2 answers
Horizontal bar plot python
Python
0 vote152 views1 answer
Zlib decompress python
Python
2 votes155 views2 answers
How to round to the nearest 25 python
Python