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( …

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	2206	November 22, 2023
use python function in annotate Using Django	3	3523	October 30, 2020
Join two models on geometry predicate Using the ORM	6	640	November 15, 2023
At a loss with ordering by one field and making distinct on another Using Django	3	1068	August 10, 2020
annotate with subquery in Django Using Django	13	8810	June 26, 2020

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

Related topics