#29338: Can't use OuterRef in union Subquery -------------------------------------+------------------------------------- Reporter: Matthew | Owner: nobody Pava | Type: Bug | Status: new Component: Database | Version: 2.0 layer (models, ORM) | Severity: Normal | Keywords: Triage Stage: | Has patch: 0 Unreviewed | Needs documentation: 0 | Needs tests: 0 Patch needs improvement: 0 | Easy pickings: 0 UI/UX: 0 | -------------------------------------+------------------------------------- When you make a QuerySet using the `union` method or the `|` operator, the QuerySet passed into the `union` method cannot reference `OuterRef` even when wrapped with `Subquery`.
For example: {{{ cls = Document.objects.filter( checklist__isnull=False, part=OuterRef('id') ).values('checklist__customer', 'created') ots = Document.objects.filter( ownershiptransfer__isnull=False, part=OuterRef('id') ).values('ownershiptransfer__ship_target__contact', 'created') return self.annotate( owner=Subquery(cls.union(ots).values('owner')[:1]) ) }}} Returns this error: {{{ ValueError This queryset contains a reference to an outer query and may only be used in a subquery. }}} I get the same error with this statement: {{{ return self.annotate( owner=Subquery((cls | ots).values('owner')[:1]) ) }}} (As an aside, I also get an error when I try to apply an `order_by` clause.) -- Ticket URL: <https://code.djangoproject.com/ticket/29338> 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 unsubscribe from this group and stop receiving emails from it, send an email to django-updates+unsubscr...@googlegroups.com. To post to this group, send email to django-updates@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/049.c28ef28c1e096380f89084b82983f494%40djangoproject.com. For more options, visit https://groups.google.com/d/optout.