/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

1 vote212 views1 answer
How to create routes in flask
Python Flask
0 vote162 views1 answer
Add list of dictionaries to pandas dataframe
Python
2 votes167 views1 answer
Python how to unnest a nested list
Python
0 vote192 views1 answer
Torch.cuda.randn
Python
27 votes173 views3 answers
How to convert exe file to python file
Python
17 votes164 views2 answers
WARNING: You are using pip version 19.2.3, however version 21.2.4 is available.
Python
0 vote177 views2 answers
In python, i am pustin two star before paramerter what is that men
Python
0 vote158 views1 answer
How to save a python object in a file
Python
0 vote169 views1 answer
Pytorch use multiple gpu
Python
0 vote179 views1 answer
How to encode hexadecimal python
Python