我正在用django.While构建一个社交媒体网站,我试图列出索引页面中的所有评论,我得到了这个错误,精确查找的QuerySet值必须限制在一个使用切片的结果上。
在这种情况下我该怎么办?
views.py...
def index(request):
if request.user.is_authenticated:
allPost = Post.objects.all().order_by('-created_on').filter(creater = request.user)
allBlog = Blogpost.objects.all()
comments = PostComment.objects.filter(post=allPost)
context = {'allPost' : allPost, 'allBlog' : allBlog, 'comments' : comments}
return render(request, 'index.html', context)
else:
return render(request, "signoption.html")
models.py...
class PostComment(models.Model):
sno = models.AutoField(primary_key=True)
comment = models.TextField()
user = models.ForeignKey(User, on_delete=models.CASCADE)
post = models.ForeignKey(Post, on_delete=models.CASCADE)
parent = models.ForeignKey('self', on_delete=models.CASCADE, null=True)
created_on = models.DateTimeField(default=timezone.now)
def __str__(self):
return str(self.sno) + '.....comment By.....' + str(self.user)
index.html...
{% for comment in comments %}
<div class="comment">
<div class="comment-user">
<div class="comment-usr-dp">
<img src="{%static 'img/profile/profile.png'%}" alt="">
</div>
</div>
<div class="comments-usr-usrname">
<b><h1>{{comment.user.username}}</h1></b>
</div>
<div class="comment-text">
<h1>{{comment.comment}}</h1>
</div>
<div class="comment-time">
<h1>{{comment.created_on}}</h1>
</div>
</div>
{%endfor%}
发布于 2022-01-11 13:52:39
将comments = PostComment.objects.filter(post=allPost)
更新为
comments = PostComment.objects.filter(post__in=allPost)
注意:post__in in filter。
https://stackoverflow.com/questions/70672068
复制