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 closed Database layer (models, ORM) 1.3 Normal invalid krzysiumed@… Unreviewed 0 0 0 0 0 0