python - Django，查询相关字段: related field exists which meet conditions

Question

假设您有问答模型。

我希望问题的答案既不会被删除，也不会被审查。
(我想要以下函数返回 True 的问题。)

def has_active_answer(self):
   return self.answers.not_deleted().filter(is_inreview=False).exists()


not_deleted() === filter(deleted=False) # if that makes difference

Answer 1

假设模型是Question并且它有answers字段:

Question.objects.filter(answers__deleted=False, answers__is_inreview=False)