/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 vote216 views1 answer
Django builtin signals
Python Django
0 vote171 views1 answer
How to send variable to python using xlwings
Python
1 vote175 views1 answer
If none in column remove row
Python
0 vote202 views1 answer
For loop to convert a list to lowercase
Python
6 votes179 views1 answer
Check 32 or 64 bit python
Python
0 vote167 views2 answers
Python error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
Python
9 votes162 views3 answers
Print for loop in same line python
Python
0 vote182 views1 answer
Box Plot, Python
Python
0 vote163 views1 answer
Python Django How To Bulk Update
Python
0 vote160 views2 answers
How to download excel file with password from online python
Python