I have two samples in an application built using Django:
JavaScript
x
6
1
class User(models.Model):
2
email = models.EmailField()
3
4
class Product(models.Model):
5
user = models.ForeignKey(User)
6
I want to filter out all users who don’t have any products in the store.
How do I do this?
Advertisement
Answer
This seems the simplest:
JavaScript
1
4
1
user_ids_with_product = [product.user_id for product
2
in Product.objects.all()]
3
Users.objects.exclude(id__in=user_ids_with_product)
4