Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#17176 closed Bug (worksforme)

Problem when retrieving objects with AND over multiple OR statements

Reported by: Haisheng HU Owned by: nobody
Component: Database layer (models, ORM) Version: 1.3
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


I'm using Django 1.3 on MongoDB, and met a weird situation.


Q(owner=u'A') | Q(owner=u'B'),
Q(owner=u'C') | Q(owner=u'D'),


The above returned queryset is same to Project.objects.filter(Q(owner=u'C') | Q(owner=u'D')), but not None, as expected. It seems that the first half lookup function was omitted.

Does someone know that it's problem with Django or third-party mongodb-engine libraries? Thanks in ad!

Change History (2)

comment:1 Changed 5 years ago by Aymeric Augustin

Needs documentation: unset
Needs tests: unset
Patch needs improvement: unset
Resolution: worksforme
Status: newclosed

It isn't a problem with Django:

>>> AutoName.objects.all()
[<AutoName: A>, <AutoName: C>]
>>> AutoName.objects.filter(Q(name=u'A') | Q(name=u'B'), Q(name=u'C') | Q(name=u'D'))
>>> AutoName.objects.filter(Q(name=u'A') | Q(name=u'B'))
[<AutoName: A>]
>>> AutoName.objects.filter(Q(name=u'C') | Q(name=u'D'))
[<AutoName: C>]

(example with the models from

comment:2 Changed 5 years ago by Haisheng HU

Thanks for your quick input. Then what is the related package? Any advice is appreciated!

Note: See TracTickets for help on using tickets.
Back to Top