CODEWITHSUNDEEP
pythondjangogeodjango
sam23
sam23

Reputation: 599

django use column value for filtering

I have a table of points with location data as stored in the following columns:

coordinates: the geolocation data in longitude and latitude
radius:      the distance from coordinate that it is visible

Now I take a random point and want to find the points that are visible to the random point using django geolocation such as:

LocationInfo.objects.filter(coordinates__distance_lt=(random_point, D(km=1))

Currently I am retrieving the points within 1 km radius but I want to use the radius from the table. How can I use the radius from the table?

Upvotes: 1

Views: 1733

Answers (1)

user8060120
user8060120

Reputation:

filters-can-reference-fields-on-the-model

from django.db.models import F

LocationInfo.objects.filter(
    coordinates__distance_lt=(random_point, D(km=F('FIELD_NAME'))
)
#                                               ^^^^^^^

Upvotes: 4

Related Questions