Django ORM: Group by and Max

by 
from django.db.models.aggregates import Max

request_values = Requests.objects.filter(req_text="YES") \
                 .values('user') \
                 .annotate(max_id=Max('id'))

Then request_values will look like this:

[
    {'user': 1, 'max_id': 1},
    {'user': 2, 'max_id': 4},
    {'user': 3, 'max_id': 5},
    {'user': 4, 'max_id': 12},
    ...
]

More Related Contents:

  1. Issue with ManyToMany Relationships not updating immediately after save
  2. How to view corresponding SQL query of the Django ORM’s queryset?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. How to rename items in values() in Django?
  6. django-orm case-insensitive order by
  7. Django: implementing JOIN using Django ORM?
  8. Chaining multiple filter() in Django, is this a bug?
  9. List field in model?
  10. How to query Case-insensitive data in Django ORM?
  11. Default image for ImageField in Django’s ORM
  12. Django: ManyToMany filter matching on ALL items in a list
  13. How to use custom manager with related objects?
  14. Django queryset get exact manytomany lookup [duplicate]
  15. Creating Partial Indexes with Django 1.7
  16. Saving Many To Many data via a modelform in Django
  17. Proper way to handle multiple forms on one page in Django
  18. Django Forms: if not valid, show form with error message
  19. 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)
  20. How can I change the default Django date template format?
  21. Django Rest Framework: Dynamically return subset of fields
  22. Django orm get latest for each group
  23. What’s the cleanest, simplest-to-get running datepicker in Django?
  24. Django : Unable to import model from another App
  25. django.db.utils.IntegrityError: UNIQUE constraint failed: rango_category__new.slug
  26. Django class based view ListView with form
  27. Setting default value for Foreign Key attribute
  28. ModelForm with OneToOneField in Django
  29. Get type of Django form widget from within template
  30. How to simplify migrations in Django 1.7?

Leave a Comment