Distance-based search on a nested data table
I have a Room data table with a one to one relationship with an Address data table. The Address table has 'coordinates' column which is a geopoint relationship.
I'm trying to do a distance-based search on the Room data table with following where clause:
However I get "Invalid where clause: Possible to use only number value or 'latitude' or 'longitude' in distance function"
How this can be done?
Search on the Address table with