Reputation: 6310
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
Upvotes: 5
Views: 3207
Reputation: 74755
@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.
Upvotes: 4