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