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 =

Limiting a SubQuery based on instance's OuterRef

Hello there! Is it possible to limit a SubQuery to a dynamic value of an instance in a QuerySet? I.e. I'm looking for something like: queryset = model.objects.filter(field=OuterRef('field')).values('another_field')[:OuterRef('number')] Sincerely, Nick Gas