/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 vote285 views1 answer
Jupyter notebook cell background color
Python
1 vote291 views1 answer
Passing Functions Around python
Python
0 vote368 views1 answer
How to delete all instances of a model in django
Python Django
0 vote287 views1 answer
Read all the lines as a list in a file using the readlines() function
Python
0 vote259 views1 answer
Matplotlib savefig legend cut off
Python
0 vote271 views1 answer
Custom pylatex command
Python
0 vote278 views1 answer
Python bangla packages
Python
1 vote296 views3 answers
Check space in string python
Python
19 votes286 views5 answers
Python floor
Python
2 votes382 views2 answers
Django template array index
Python Django