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 29009 "Error using jsonpickle.encode() on a QuerySet with a Subquery: ""This queryset contains a reference to an outer query and may only be used in a subquery""" Vasiliy Maryutenkov nobody "Hello I've tried to serialize queryset with Subquery object and it failed with that error. ""This queryset contains a reference to an outer query and may only be used in a subquery"" {{{ subquery = Transaction.objects.filter(user=OuterRef('pk')).values('user').order_by('user').annotate(txs=Count('*')).annotate(txs_value=Sum(F('tx_value')*F('symbol__price_in_eth'))).annotate(txs_value_eur=Sum((F('tx_value')*F('symbol__price_in_eth'))/eur.price_in_eth)) investors_qs = User.objects.filter(ether_wallet__isnull=False).annotate(txs=Subquery(subquery.values('txs')[:1])).annotate(txs_value=Subquery(subquery.values('txs_value')[:1])).annotate(txs_value_eur=Subquery(subquery.values('txs_value_eur')[:1])) jsonpickle.encode(investors_qs.query) 'This queryset contains a reference to an outer query and may ' ValueError: This queryset contains a reference to an outer query and may only be used in a subquery. }}} is it normal behaviour or a bug?" Bug closed Database layer (models, ORM) 2.0 Normal needsinfo Unreviewed 0 0 0 0 0 0