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
annotate with subquery in Django Using Django	13	6240	June 26, 2020
Postgis Point Creation Using the ORM	13	762	October 19, 2023
TypeError: float() argument must be a string or a real number, not 'F' Using the ORM	7	1910	November 22, 2023
Annotate duration/integer -> MySql error Using the ORM	16	1482	March 28, 2022
Join two models on geometry predicate Using the ORM	6	532	November 15, 2023

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

Related topics