CODEWITHSUNDEEP
pythondjangomany-to-manydjango-queryset
Tanvir Ahmed
Tanvir Ahmed

Reputation: 387

Flitering django queryset based on ManyToManyField

In my Request model, there is a field requested_to which is a ManyToManyField

requested_to = models.ManyToManyField(OrganizationUser)

I want to filter queryset of Request model where a organization_user is not in requested_to

Upvotes: 2

Views: 62

Answers (1)

willeM_ Van Onsem
willeM_ Van Onsem

Reputation: 477684

You can filter with:

Request.objects.exclude(requested_to=organization_user)

Django makes LEFT OUTER JOINs when you filter on a ManyToManyField (or a reverse ForeignKey), so here we exclude all Requests where organization_user is a member of the requested_to.

Upvotes: 1

Related Questions