Search code examples
djangojoinmany-to-manymanytomanyfield

Django select objects with empty ManyToManyField


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 = models.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

Solution

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