django most efficient way to count same field values in a query

by

You want something similar to “count … group by”. You can do this with the aggregation features of django’s ORM:

from django.db.models import Count

fieldname="myCharField"
MyModel.objects.values(fieldname)
    .order_by(fieldname)
    .annotate(the_count=Count(fieldname))

Previous questions on this subject:

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. Custom QuerySet and Manager without breaking DRY?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. Raw SQL queries in Django views
  6. How to limit queryset/the records to view in Django admin site?
  7. Django: implementing JOIN using Django ORM?
  8. Django – filtering on foreign key properties
  9. Django query datetime for objects older than 5 hours
  10. Django: Does prefetch_related() follow reverse relationship lookup?
  11. Django Order By Date, but have “None” at end?
  12. how to write a query to get find value in a json field in django
  13. What’s the difference between django OneToOneField and ForeignKey?
  14. How do I do a not equal in Django queryset filtering?
  15. In a django model custom save() method, how should you identify a new object?
  16. Unique fields that allow nulls in Django
  17. Tying in to Django Admin’s Model History
  18. Django values_list vs values
  19. django dynamically filtering with q objects
  20. How to assign currently logged in user as default value for a model field?
  21. Django – Simple custom template tag example
  22. Django user profile
  23. How can I restrict Django’s GenericForeignKey to a list of models?
  24. Django ManyToMany model validation
  25. Django – Overriding the Model.create() method?
  26. How to create a Django queryset filter comparing two date fields in the same model
  27. Multiple images per Model
  28. Django Queryset with filtering on reverse foreign key
  29. Can Django automatically create a related one-to-one model?
  30. QuerySet, Object has no attribute id – Django

Leave a Comment