Fetch collection by localization

[Apptrix]

I’m using supabase with postgis to bring records by geolocation, but how can I do this select on the web?

SELECT * FROM cadastro_servicos
WHERE ST_DWithin(
location,
ST_MakePoint(CAST(longitude_specifies AS float), CAST(latitude_specifies AS float))::GEOGRAPHY,
10000
);

[Alexis]

Hi, you should create a postgres function inside supabase containing your query, and then in WeWeb use the “Call a postgres function” action

[Apptrix]

I did it thank you very much