How to count a filtered result in Django?

Question

I have managed to create a QuerySet of what I want so far, but I am unable to include the .count () statement in it. I do know that I can use len (students), but I would like to stick to the Django ORM.

student_count = Student.objects.filter(last_online__range=[last week, this week])

How do I do that?

why `Student.objects.filter(last_online__range=[last week, this week]).count()` is not working? — Mahmoud Adel, Apr 29 '21 at 01:34
`Student.objects.filter(last_online__range=[last week, this week]).count()` doesn't work? — elyas, Apr 29 '21 at 01:34
Could be duplicate/related :https://stackoverflow.com/questions/5439901/getting-a-count-of-objects-in-a-queryset-in-django — Orville, Apr 29 '21 at 01:35
`.count()` at the end does work. You can add it as the answer and I'll accept it — uber, Apr 29 '21 at 01:45

score 2 · Accepted Answer · answered Apr 30 '21 at 00:44

2

You can use count()

Student.objects.filter(last_online__range=[last week, this week]).count()

answered Apr 30 '21 at 00:44

Mahmoud Adel

1,262
2
13
23

Max · Answer 2 · 2021-04-29T01:38:10.773

1

you can use aggregate() to count, like this:

student_count = Student.objects.filter(last_online__range=[last week, this week]).aggregate(Count('MODEL_FILE'))

The function of Django's aggregate() method is to perform statistical calculations on a set of values (such as a field of the queryset) and return the statistical calculation results in a dictionary (Dict) format.

edited Apr 29 '21 at 01:38

answered Apr 29 '21 at 01:33

Max

836
6
13

How to count a filtered result in Django?

2 Answers2