Opened 7 years ago

Last modified 9 months ago

#28333 assigned New feature

Filter and subquery for window expressions — at Version 1

Reported by: Mads Jensen Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: window orm filter subquery GSoC
Cc: Alexandr Artemyev, Andy Terra, Étienne Beaulé, Michael Wheeler, şuayip üzülmez, John Speno, Alex Scott, Ad Timmering, Hannes Ljungberg, Dave Johansen, Simon Charette Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Mads Jensen)

#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.

Change History (1)

comment:1 by Mads Jensen, 7 years ago

Description: modified (diff)
Triage Stage: Unreviewed → Accepted
Note: See TracTickets for help on using tickets.
Back to Top