我有发票模型
class Invoice(models.Model):
name = models.ForeignKey('Patient', on_delete=models.CASCADE)
我有另一种发票金额模型,其发票FK为
class InvoiceAmount(models.Model):
invoice = models.ForeignKey('Invoice', on_delete=models.CASCADE)
amount = models.IntegerField(default=0)
is_paid = models.BooleanField(default=False)
我想要获得IS_Payed=真实发票金额的发票
我正在使用此查询,但它不起作用
Invoice.objects.annotate(all_paid=Exists(InvoiceAmount.objects.filter(is_paid=True, id=OuterRef('pk')))).filter(all_paid=True)