Django annotate count with a distinct field

by

Count can take a distinct argument, like so:

p = Project.objects.all().annotate(Count('informationunit__username', 
                                         distinct=True))

This doesn’t seem to be documented, but you can find it in the source for Count.

More Related Contents:

  1. Pillow installed, but getting “no module named pillow”
  2. How to query as GROUP BY in django?
  3. How do I filter query objects by date range in Django?
  4. Does Django scale? [closed]
  5. In Django, how does one filter a QuerySet with dynamic field lookups?
  6. Django equivalent for count and group by
  7. How to redirect with post data (Django)
  8. Django/Python Beginner: Error when executing python manage.py syncdb – psycopg2 not found
  9. Django REST Framework POST nested objects
  10. ImportError: No module named ‘django.core.urlresolvers’
  11. How does Django Know the Order to Render Form Fields?
  12. Django server killed frequently
  13. Django Server Error: port is already in use
  14. django-filter use paginations
  15. ValueError at /image/ Tensor Tensor(“activation_5/Softmax:0”, shape=(?, 4), dtype=float32) is not an element of this graph
  16. Django: Display Choice Value
  17. Django Multiple Choice Field / Checkbox Select Multiple
  18. Django – taking values from POST request
  19. Django REST: Uploading and serializing multiple images
  20. Django Rest Framework – Authentication credentials were not provided
  21. Create Django model or update if exists
  22. Get request body as string in Django
  23. Overriding the save method in Django ModelForm
  24. Django class-based view: How do I pass additional parameters to the as_view method?
  25. “no such table” exception
  26. Case insensitive unique model fields in Django?
  27. Proper way to consume data from RESTFUL API in django
  28. django makemigrations and migrate on heroku server don’t create tables
  29. Django-registration, force unique e-mail
  30. Django cannot import name x [duplicate]

Leave a Comment