# 모델
class Product(models.Model):
...
class Review(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE, null=True, default=None)
content = models.Textfield()
...
...
# 쿼리셋
def get_queryset(request):
queryset = super().get_queryset(request)
product_reviews = Review.objects.filter(
product_id=OuterRef('pk'))
latest_review = (
product_reviews.order_by('-pk'))
queryset = queryset.annotate(
latest_review=Subquery(
latest_review.values('content')[:1]),
)
return queryset