id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
17665	Inconsitent behaviour of filter() with multi-valued relations.	Łukasz Rekucki	nobody	"This is probably a duplicate as I recall seeing a similar issue, but I couldn't find it, so here it goes:

We have 2 models (lets say, Company and Person), connected thru a M2M table (Membership) with additional attribute ""active"".

The following queries work as documented:

{{{
base = Company.objects.all()

# 1) select all companies in which person 1 is active
base.filter(membership_set__active=True, membership_set__person=1)

# 2) select all companies in which some membership is active or person '1' is a member
base.filter(membership_set__active=True).filter(membership_set__person=1)
}}}

But if you apply the {{{filter()}} directly to the manager:

{{{Company.objects.filter(membership_set__active=True, membership_set__person=1)}}}

The behaviour is the same as query 2), while it should work like 1)."	Bug	new	Database layer (models, ORM)	1.3	Normal				Unreviewed	0	0	0	0	0	0