So I want make some query based in lon/lat values of a specific place. A simple example is this:
SELECT C.tipo, C.geomFROM climas AS CWHERE ST_Contains(ST_SetSRID(C.geom, 4326), ST_SetSRID(ST_Point(%x%, %y%), 4326))As default values for x and y, I put the lon/lat coordinates of my city (-44, -3)
The problem is, when I visualize the layer without params, this works. When I put the params, if they are negative, I receive a message saying:
أكثر...
SELECT C.tipo, C.geomFROM climas AS CWHERE ST_Contains(ST_SetSRID(C.geom, 4326), ST_SetSRID(ST_Point(%x%, %y%), 4326))As default values for x and y, I put the lon/lat coordinates of my city (-44, -3)
The problem is, when I visualize the layer without params, this works. When I put the params, if they are negative, I receive a message saying:
error:java.lang.RuntimeException: java.io.IOException java.lang.RuntimeException: java.io.IOException java.io.IOExceptionInvalid value for parameter x
I'm using the default regular expression hinted by geoserver. Need something for negative values in the URL? Or maybe the regular expression isn't correct?
أكثر...