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
28333	Filter and subquery for window expressions	Mads Jensen	nobody	"#26608 will introduce window function expressions, but will disallow filtering on the result of them, e.g.:

{{{
Window.objects.annotate(row=Window(expression=RowNumber())).filter(row__gt=1)
}}}

is not allowed. Instead, the window function expression should be wrapped in an inner query, and the filtering should be done in an outer query."	New feature	new	Database layer (models, ORM)	dev	Normal		window orm filter subquery		Accepted	0	0	0	0	0	0