我的搜索功能运行得很好,但每次我试图在我的网站上搜索一个存在的帖子时,它都会给我带来一个错误.当我在category字段下的问题模型中删除ForeignKey时,错误消失了.请告诉我如何筛选ForeignKey的类别
错误:
FieldError at /index/
Related Field got invalid lookup: category
我的型号:
class Category(models.Model):
name = models.CharField(max_length=100, blank=False, null=False)
def __str__(self):
return str(self.name)
class Question(models.Model):
user = models.ForeignKey(User, on_delete=models.CASCADE)
title = models.CharField(max_length=100, blank=False, null=False)
body = RichTextField(blank=False, null=False)
category = models.ForeignKey(Category, on_delete=models.CASCADE)
slug = models.SlugField(unique=True, max_length=200)
def save(self, *args, **kwargs):
self.slug = slugify(self.title)
super(Question, self).save(*args, **kwargs)
def __str__(self):
return str(self.title)
视图:
def index(request):
query = request.GET.get('q', None)
list_of_question = Question.objects.all()
if query is not None:
list_of_question = Question.objects.filter(
Q(title__icontains=query) |
Q(category__category__icontains=query)
)
unread_notifications = Notification.objects.filter(user=request.user, is_read=False).count()
paginator = Paginator(list_of_question, per_page=1)
return render(request, 'index.html', {'unread_notifications':unread_notifications,'list_of_question':list_of_question, 'paginator':paginator})
我的表格:
<form action="" method="GET">
<input placeholder="Search By Category" type="text" class="form-control" name="q">
</form>