我的项目允许用户写一篇帖子，每个帖子都有一个类别，每个类别都有一名主管，所以我面临着一个问题，我无法获得特定主管的特定类别的所有帖子。
我的型号
class PostCategory(models.Model):
name = models.CharField(max_length=150, null=True)
description = models.CharField(max_length=100, null=True)
def __str__(self):
return self.name
class UserSupervisorSpecialist(models.Model):
user = models.ForeignKey(User, related_name="user_id", on_delete=models.SET_NULL, null=True)
category = models.OneToOneField(CategoryPost, related_name="category_id", on_delete=models.SET_NULL, null=True)
def __str__(self):
return self.user.username
class Post(models.Model):
title = models.CharField(max_length=100, null=True)
content = RichTextField()
post_category = models.ManyToManyField(CategoryPost)
author = models.ForeignKey(User, on_delete=models.SET_NULL, null=True)
date_create = models.DateTimeField(auto_now_add=True, null=True)
status = models.BooleanField(default=False) #0 -> suspend
likes = models.IntegerField(default=0) #0 -> No like yet
supervisor = models.ForeignKey(UserSupervisorSpecialist, on_delete=models.SET_NULL, null=True)
def __str__(self):
return self.title
def snippet(self):
return self.content[:150]
我的观点：
def control_spanle(request):
category = UserSupervisorSpecialist.objects.filter(user=request.user)
post_filter = Post.objects.filter(supervisor=request.user.username)
return render(request, 'supervisor/controle_panel.html',{'Category':category,'post_filter':post_filter})
您在Post模型上编写了一个查询集，但没有指定字段，而是将其与字符串进行比较。
您可以通过更改此行来解决此问题
post_filter = Post.objects.filter(supervisor=request.user.username)
至：
post_filter = Post.objects.filter(supervisor__name=request.user.username)