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/database-functions/#rownumber

Le mardi 29 janvier 2019 07:48:07 UTC-5, Nick Gashkov a écrit :

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 Gashkov

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/113755a9-fe8e-40ec-866b-091ed3c2d381%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.