Trey Hunner 🐍 on Nostr: Since you don't want values but actual model objects instead, you may need to use a ...

Since you don't want values but actual model objects instead, you may need to use a subquery.

This maybe?

subquery = (
ContainerBase.objects
.filter(cname=OuterRef('cname'))
.values('cname')
.annotate(max_ctime=Max('ctime'))
.values('max_ctime')
)

query = (
ContainerBase.objects
.annotate(max_ctime=Subquery(subquery))
.filter(ctime=F('max_ctime'))
.order_by('cname')
.distinct('cname')
)