﻿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
33959	"Missing import in ""Expressions can reference transforms"" section"	Eido Askayo	Iván Triviño	"In section [https://docs.djangoproject.com/en/4.0/topics/db/queries/#expressions-can-reference-transforms Expressions can reference transforms], the following code is shown:
{{{
>>> Entry.objects.values('pub_date__year').annotate(
...     top_rating=Subquery(
...         Entry.objects.filter(
...             pub_date__year=OuterRef('pub_date__year')
...         ).order_by('-rating').values('rating')[:1]
...     ),
...     total_comments=Sum('number_of_comments'))
}}}
There are missing imports for {{{Subquery}}}, {{{OuterRef}}} and {{{Sum}}} functions:
{{{
>>> from django.db.models import Subquery, OuterRef, Sum
}}}
"	Bug	closed	Documentation	4.0	Normal	duplicate			Unreviewed	0	0	0	0	0	0
