Django 1.11 Annotating a Subquery Aggregate

by

Shazaam! Per my edits, an additional column was being output from my subquery. This was to facilitate ordering (which just isn’t required in a COUNT).

I just needed to remove the prescribed meta-order from the model. You can do this by just adding an empty .order_by() to the subquery. In my code terms that meant:

from django.db.models import Count, OuterRef, Subquery

spaces = Space.objects.filter(carpark=OuterRef('pk')).order_by().values('carpark')
count_spaces = spaces.annotate(c=Count('*')).values('c')
Carpark.objects.annotate(space_count=Subquery(count_spaces))

And that works. Superbly. So annoying.

More Related Contents:

  1. Django: Group by date (day, month, year)
  2. How to group by AND aggregate with Django
  3. Proper way to handle multiple forms on one page in Django
  4. Django Forms: if not valid, show form with error message
  5. How to set a Django model field’s default value to a function call / callable (e.g., a date relative to the time of model object creation)
  6. Custom error messages in Django Rest Framework serializer
  7. Redirect to named url pattern directly from urls.py in django?
  8. What’s the recommended approach to resetting migration history using Django South?
  9. IntegrityError duplicate key value violates unique constraint – django/postgres
  10. How can I detect multiple logins into a Django web application from different locations?
  11. Django/jQuery Cascading Select Boxes?
  12. How to set current user to user field in Django Rest Framework?
  13. Django model instances primary keys do not reset to 1 after all instances are deleted
  14. Django form with choices but also with freetext option?
  15. How to run a celery worker with Django app scalable by AWS Elastic Beanstalk?
  16. Django Queryset with filtering on reverse foreign key
  17. Can Django automatically create a related one-to-one model?
  18. Django how to pass custom variables to context to use in custom admin template?
  19. Django Admin – Overriding the widget of a custom form field
  20. Make Django forms use comma as decimal separator
  21. Django – show loading message during long processing
  22. Django model with 2 foreign keys from the same table
  23. How to add Check Constraints for Django Model fields?
  24. Django templates folders
  25. Django queryset get exact manytomany lookup [duplicate]
  26. 110: Connection timed out (Nginx/Gunicorn)
  27. How to show related items using DeleteView in Django?
  28. Django Programming error column does not exist even after running migrations
  29. Django – Static file not found
  30. django: how to access current request user in ModelForm?

Leave a Comment