Hi. I am on Django 3.2 using Python 3.8 and Postgres. I’m trying to annotate the distance between a user and facility. My minimal code is as follows: User.objects.all().annotate( test=Subquery( Facility.objects.annotate( distance=Distance("facility_address__pnt", OuterRef("…

I think you might have to wrap the OuterRef in ExpressionWrapper here to tell Distance that it will eventually resolve to a PointField User.objects.annotate( test=Facility.objects.annotate( distance=Distance( "facility_address__pnt", ExpressionWrapper( …

This expression: [image] j-krl: OuterRef("user_address__pnt")) would be a references to the outer query for User. Does your User model have a user_address field? What is the type of that field? (Superficially, I would think it would need to be either a ForeignKey or a OneToOneField to a diff…

For the record, this is tracked in this ticket .

I appreciate you pushing that forward for me. Just for my own understanding, the issue is that since I’m using the OuterRef inside a database function, the function is attempting to check the value of OuterRef before it’s fully resolved? How is that different than doing some kind of simple filterin…

The different between the two is that filter(user_id=OuterRef("pk")) translates to lookups.Exact(F("user_id"), OuterRef("pk")) which has a pre-defined output_field = BooleanField(). In the case of the Distance function it has some specialized logic to ensure that each expressions are geometric that…

Error when annotating distance between 2 points inside a Subquery - GeoDjango

Using Django Using the ORM

j-krl May 6, 2024, 2:09pm 4

Wow, thanks a million! Not sure I would have thought of that!

Topic		Replies	Views
TypeError: float() argument must be a string or a real number, not 'F' Using the ORM	7	2360	November 22, 2023
Join two models on geometry predicate Using the ORM	6	702	November 15, 2023
Simple annotation of related count using OuterRef ORM	4	360	July 11, 2025
Postgis Point Creation Using the ORM	13	1247	October 19, 2023
Using `values(..)` after `distinct(..)` over an annotated value Using the ORM	7	111	July 3, 2026

Error when annotating distance between 2 points inside a Subquery - GeoDjango

Related topics