Using a parametric coordinate in sql view geoserver

[المشرف العام]

In geoserver I create a parameter view :

select nama_hotel,geom from hotel_mau_fix where st_distance(ST_TRANSFORM(ST_SETSRID(geom,4326),32749),ST_TRANSFORM(ST_SETSRID(ST_GEOMETRYFROMTEXT('POINT (%koord_x% %koord_y%)'),4326),32749))