#17665: Inconsitent behaviour of filter() with multi-valued relations.
-------------------------------------+-------------------------------------
Reporter: lrekucki | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.3
(models, ORM) | Resolution:
Severity: Normal | Triage Stage:
Keywords: | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by lrekucki:
Old description:
> 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).
New description:
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).
--
--
Ticket URL: <https://code.djangoproject.com/ticket/17665#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
