Count number of records by date in Django

by

This should work (using the same MySQL specific function you used):

Review.objects.filter(venue__pk=2)
    .extra({'date_created' : "date(datetime_created)"})
    .values('date_created')
    .annotate(created_count=Count('id'))

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Django Aggregation: Summation of Multiplication of two fields
  3. How do I do a not equal in Django queryset filtering?
  4. Django values_list vs values
  5. “_set” in a queryset object in Django
  6. QuerySet, Object has no attribute id – Django
  7. Get the latest record with filter in Django
  8. Django filter JSONField list of dicts
  9. How to delete a record in Django models?
  10. Can a dictionary be passed to django models on create?
  11. How to query as GROUP BY in django?
  12. Convert Django Model object to dict with all of the fields intact
  13. Django auto_now and auto_now_add
  14. Programmatically saving image to Django ImageField
  15. Django FileField with upload_to determined at runtime
  16. how to import csv data into django models
  17. In Django, how does one filter a QuerySet with dynamic field lookups?
  18. How to get two random records with Django
  19. What is the most efficient way to store a list in the Django models?
  20. Is this the way to validate Django model fields?
  21. Django: Display Choice Value
  22. Django – How to rename a model field using South?
  23. Create Django model or update if exists
  24. Django Admin nested inline
  25. How to have a Python script for a Django app that accesses models without using the manage.py shell?
  26. How to display uploaded images in “Change List” page in Django Admin?
  27. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  28. How to do many-to-many Django query to find book with 2 given authors?
  29. How can I set two primary key fields for my models in Django?
  30. Django foreign key relation in template

Leave a Comment