Parameterizing Postgis function in GeoServer's SQL Views

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

I have a problem when parameterizing a postgis function in sqlviewsIf i create this sql, all works like a charm attaching this &viewparams=idvia:6753 to the url

SELECT ST_Transform(ST_LocateAlong(geom,10000),4326) as pkfrom rutascalibradas where idvia = '%idvia%'But if i want to convert the number 10000 to a parameter

SELECT ST_Transform(ST_LocateAlong(geom,%pk%),4326) as pkfrom rutascalibradas where idvia = '%idvia%'Geoserver says: ERROR: syntax error at or near ")" Position: 56

Thank you for your effort



أكثر...