Django Query That Get Most Recent Objects From Different Categories

by

Starting from Django 1.11 and thanks to Subquery and OuterRef, we can finally build a latest-per-group query using the ORM.

hottest_cakes = Cake.objects.filter(
    baked_at=Subquery(
        (Cake.objects
            .filter(bakery=OuterRef('bakery'))
            .values('bakery')
            .annotate(last_bake=Max('baked_at'))
            .values('last_bake')[:1]
        )
    )
)

#BONUS, we can now use this for prefetch_related()
bakeries = Bakery.objects.all().prefetch_related(
    Prefetch('cake_set',
        queryset=hottest_cakes,
        to_attr="hottest_cakes"
    )
)

#usage
for bakery in bakeries:
    print 'Bakery %s has %s hottest_cakes' % (bakery, len(bakery.hottest_cakes))

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Django filter queryset __in for *every* item in list
  3. Django Aggregation: Summation of Multiplication of two fields
  4. How can I filter a date of a DateTimeField in Django?
  5. How can I filter a Django query with a list of values?
  6. Getting the SQL from a Django QuerySet [duplicate]
  7. How do I do a not equal in Django queryset filtering?
  8. How do I get the object if it exists, or None if it does not exist in Django?
  9. Django orm get latest for each group
  10. django – convert a list back to a queryset [duplicate]
  11. Django values_list vs values
  12. many-to-many in list display django
  13. How to combine multiple querysets in Django?
  14. “_set” in a queryset object in Django
  15. Count number of records by date in Django
  16. aggregate() vs annotate() in Django
  17. Count() vs len() on a Django QuerySet
  18. How to perform OR condition in django queryset?
  19. Simple Subquery with OuterRef
  20. QuerySet, Object has no attribute id – Django
  21. Django custom annotation function
  22. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  23. How to do many-to-many Django query to find book with 2 given authors?
  24. Get the latest record with filter in Django
  25. django filter on the basis of text length
  26. Django filter JSONField list of dicts
  27. How to annotate Count with a condition in a Django queryset
  28. How to delete a record in Django models?
  29. Can a dictionary be passed to django models on create?
  30. What’s the purpose of Django setting ‘SECRET_KEY’?

Leave a Comment