开发者

Django select objects with empty ManyToManyField

开发者 https://www.devze.com 2023-01-19 02:56 出处:网络
Considering the following models, knowing a family, how do I select Kids with no buyers? class Family...

Considering the following models, knowing a family, how do I select Kids with no buyers?

class Family...

class Kid(models.Model):
    name = models.CharField(max_length=255)
    family = mod开发者_运维问答els.ForeignKey(Family)
    buyer = models.ManyToManyField(Buyer, blank=True, null=True)

family = get_object_or_404(Family, pk=1)
for_sale = family.kid_set.filter(buyer... this screws my child trade business


family.kid_set.filter(buyer__isnull=True) should work.


@piquadrat's answer is correct. You can also do:

for_sale = Kid.objects.filter(family__pk = 1, buyer = None)

This lets you avoid a separate query to look up the Family instance.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号