Including a cql_filter with arithmetic _expression_ before IN function (i.e. PERSONS/10 IN (247757.4)) results in a parsing error. The resulting map should just show Kansas as PERSONS IN (244574) matches that. Request: http://localhost:8080/geoserver/wms?service=WMS&version=1.1.0&request=GetMap&layers=topp:states&styles=&bbox=-124.73142200000001,24.955967,-66.969849,49.371735&width=768&height=330&srs=EPSG:4326&format=application/openlayers&cql_filter=(PERSONS/10)%20IN%20(247757.4) Error: <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ServiceExceptionReport SYSTEM "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1" > <ServiceException> Could not parse CQL filter list. Encountered "/ 10 ) IN" at line 1, column 9. Was expecting one of: "(" ... ":" ... <IDENTIFIER> ... "." ... "*" ... "/" "(" ... "/" "[" ... "/" <IDENTIFIER> ... "/" <DATE> ... "/" <DATE_TIME> ... "/" "-" ... "/" <INTEGER_LITERAL> "*" ... "/" <INTEGER_LITERAL> "/" ... "/" <INTEGER_LITERAL> "+" ... "/" <INTEGER_LITERAL> "-" ... "/" <INTEGER_LITERAL> ")" "*" ... "/" <INTEGER_LITERAL> ")" "/" ... "/" <INTEGER_LITERAL> ")" "+" ... "/" <INTEGER_LITERAL> ")" "-" ... "/" <INTEGER_LITERAL> ")" "not" ... "/" <INTEGER_LITERAL> ")" "like" ... "/" <INTEGER_LITERAL> ")" "ilike" ... "/" <INTEGER_LITERAL> ")" "exists" ... "/" <INTEGER_LITERAL> ")" "does-not-exist" ... "/" <INTEGER_LITERAL> ")" "is" ... "/" <INTEGER_LITERAL> ")" "between" ... "/" <INTEGER_LITERAL> ")" "=" ... "/" <INTEGER_LITERAL> ")" ">" ... "/" <INTEGER_LITERAL> ")" "<" ... "/" <INTEGER_LITERAL> ")" ">=" ... "/" <INTEGER_LITERAL> ")" "<=" ... "/" <INTEGER_LITERAL> ")" "<>" ... "not" ... "in" ... "tequals" ... "before" ... "after" ... "during" ... "/" <INTEGER_LITERAL> "not" ... "/" <INTEGER_LITERAL> "like" ... "/" <INTEGER_LITERAL> "ilike" ... "/" <INTEGER_LITERAL> "exists" ... "/" <INTEGER_LITERAL> "does-not-exist" ... "/" <INTEGER_LITERAL> "is" ... "/" <INTEGER_LITERAL> "between" ... "/" <INTEGER_LITERAL> "=" ... "/" <INTEGER_LITERAL> ">" ... "/" <INTEGER_LITERAL> "<" ... "/" <INTEGER_LITERAL> ">=" ... "/" <INTEGER_LITERAL> "<=" ... "/" <INTEGER_LITERAL> "<>" ... Parsing : (PERSONS/10) IN (247757.4). </ServiceException></ServiceExceptionReport> |