/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 vote183 views1 answer
AttributeError: module 'django.db.models' has no attribute 'ArrayField'
Python Django
1 vote163 views1 answer
How to install pandas datareader in conda
Python
10 votes151 views4 answers
Load model tensorflow
Python
3 votes155 views1 answer
Read tsv file column
Python
5 votes150 views1 answer
Pythagoras calculator
Python
0 vote154 views1 answer
Python selenium for desktop application
Python
5 votes158 views1 answer
Tkinter entry default value
Python
0 vote137 views1 answer
Pytesseract restrict char
Python
14 votes152 views6 answers
Find last element in list python
Python
1 vote179 views1 answer
How to open dialog box to select folder in python
Python