Re: Limiting a SubQuery based on instance's OuterRef

Simon, Thank you for fast reply! I've tried to rewrite a query using RowNumber()... inner_subquery = queryset.objects.filter(date__gte=today, day_type='working_day') inner_subquery = inner_subquery.annotate(row_number=Window(expression=RowNumber(), order_by=F('number').asc())) inner_subquery =

Re: Limiting a SubQuery based on instance's OuterRef

Hello Nick, It isn't possible to reference columns in a LIMIT clause AFAIK. I'd suggest you use a RowNumber[0] window function ordered by your number column in a subquery and filter on the annotated value in the outer query. Cheers, Simon [0] https://docs.djangoproject.com/en/2.1/ref/models/d