I want to pass an SQL-ending as a view param to GeoServer using WMTS. E.g. something like:
for my SQL view layer where the FILTER-variable has the following regex-validation:
The query looks something like this:
SELECT * FROM table %FILTER%
I'm getting this error from the GeoServer:
WARN [org.geoserver.ows] - Unable to parse filter: ORDER BY road_class org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
Is this at all possible, or is there some SQL-inject filter? Or is this some kind of validation error where GeoServer is unable to handle spaces?