[Answered ]-Related name returning post.commentpost.none

by

1👍

✅

You can use a Subquery expression [Django-doc] to obtain the latest content1 comment and author with:

from django.db.models import OuterRef, Subquery

last_comment = CommentPost.objects.filter(post=OuterRef('pk')).order_by('-date_posted')

my_tag = Posty.objects.annotate(
    last_comment=Subquery(last_comment.values('content1')[:1]),
    last_comment_user=Subquery(last_comment.values('user__name')[:1]),
    last_comment_user_pk=Subquery(last_comment.values('user')[:1])
).prefetch_related('my_wyswietlenia')

The __name might be different, since it depends on the fields of you Profil model.

Then you can render the content and the last author with:

{% for post in my_tag %}
    {{ post.last_comment }} by {{ post.last_coment_user }}
{% enfor %}
👤willeM_ Van Onsem

Leave a comment