Filter queryset based on related object's field value
Advertisements I have two models: class PartUse(models.Model): … imported = models.BooleanField() class PartReturn(models.Model): partuse = models.ForeignKey(PartUse) … imported = models.BooleanField() class PartUseListView(ListView): model = PartUse def get_queryset(self): if self.request.GET.get(‘show_imported’, None): qs = self.model.objects.all() else: qs = self.model.objects.filter(Exists(PartReturn.objects.filter( imported=False, id__in=OuterRef("partreturn")))) return qs I want to filter QuerySet for PartUse to return all PartUse instances that have… Read More Filter queryset based on related object's field value