How to filter objects for count annotation in Django?

by

Conditional aggregation in Django 2.0 allows you to further reduce the amount of faff this has been in the past. This will also use Postgres’ filter logic, which is somewhat faster than a sum-case (I’ve seen numbers like 20-30% bandied around).

Anyway, in your case, we’re looking at something as simple as:

from django.db.models import Q, Count
events = Event.objects.annotate(
    paid_participants=Count('participants', filter=Q(participants__is_paid=True))
)

There’s a separate section in the docs about filtering on annotations. It’s the same stuff as conditional aggregation but more like my example above. Either which way, this is a lot healthier than the gnarly subqueries I was doing before.

More Related Contents:

  1. How to query as GROUP BY in django?
  2. How do I filter query objects by date range in Django?
  3. Convert Django Model object to dict with all of the fields intact
  4. Django auto_now and auto_now_add
  5. Programmatically saving image to Django ImageField
  6. Django FileField with upload_to determined at runtime
  7. how to import csv data into django models
  8. In Django, how does one filter a QuerySet with dynamic field lookups?
  9. How do I clone a Django model instance object and save it to the database?
  10. Django Aggregation: Summation of Multiplication of two fields
  11. How to get two random records with Django
  12. What is the most efficient way to store a list in the Django models?
  13. Is this the way to validate Django model fields?
  14. Django: Display Choice Value
  15. Django: Why do some model fields clash with each other?
  16. Using a Django custom model method property in order_by()
  17. Create Django model or update if exists
  18. Split models.py into several files
  19. How do I make an auto increment integer field in Django?
  20. Django Admin nested inline
  21. How do I create a slug in Django?
  22. How to override the default value of a Model Field from an Abstract Base Class
  23. How can I find the union of two Django querysets?
  24. Django override save for model only in some cases?
  25. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  26. Identify the changed fields in django post_save signal
  27. How can I set two primary key fields for my models in Django?
  28. Django foreign key relation in template
  29. Django get_profile() method not working on extended User model
  30. How to delete a record in Django models?

Leave a Comment