charred kestrel
Not sure if it's possible or not but can the ORM resolve a related object on annotations of id?
Table definitions
Table Foo:
id
Table Bar
id
queryset = Foo.objects.annotate(
bar_id=Subquery(Bar.objects.values('id')[:1])
)
queryset[0].bar.id # Like so
I'm sure the given snippet of code doesn't work. I'm asking if there's a way to do that other than looping through the queryset and getting the object itself.
autumn monolith
No, it's not possible. What about defining a relationship between Foo and Bar?
sleek moat
This sort of explains how to do what you're looking for https://blog.bmispelon.rocks/articles/2024/2024-05-09-django-getting-a-full-model-instance-from-a-subquery.html
modest vigil
How do I give you a fist bump for this, lol.
Actually worked really well for me and what I needed to do. Thanks @sleek moat
sleek moat
You actually fist bump @versed flax! He's the author