How to store lat and lng data as geospatial point datatype in strapi v4 with mysql

Questions and Answers Database-SQL
1
System Information
  • Strapi V4:
  • OS : Windows:
  • MySQL:
  • Node v20.12.2:
  • NPM 10.5.0:
  • Yarn 1.22.22:

I tired several ways creating customField, but the data will be stored as string type.
I also tried to extend the default service & controller to tweak query but this never worked.

Other way i tired to create a custom field and type of json and data structure {lat:12.77212, lng: 14.7846} and wanted to tweak the query and save it as point(lat lng) but didnt work

Any help would be appreciated

2

Given there is no response, I’m assuming this is not possible.

Conclusion: Strapi is not usable for the use-case: fetch x records closest to given coordinates lat and lng.

If this is not true, please reply.