[mapserver-users] WMS field type errors on FES filter

[PE Lord]

Hi there!

It's the same issue from my previous thread (https://lists.osgeo.org/pipermail/mapserver-users/2022-May/082641.html)
The difference is that the issue is now with WMS with FILTER query parameters.

I've set the layer metadata with gml_types "auto" and I encounter the same issue.

This seem to be an issue with wms/filter field type definition.

Here my log:

msPostGISLayerWhichShapes(): Error (ERROR: operator does not exist: character = integer
LINE 4: ...7842 321768.066989752))',3798) and (("dirct_gen_code" = 43))

Ex: In my DB (postgresql), I have tableA withdirct_gen_code.dirct_gen_code is declared as a character(2) but the content of rows are numbers... i.e. 43
...?
SERVICE=WMS&
VERSION=1.3.0&
REQUEST=GetMap&
FORMAT=image/png&
TRANSPARENT=true&
LAYERS=tableA&
DPI=96&
MAP_RESOLUTION=96&
FORMAT_OPTIONS=dpi:96&
FILTER=
<Filter xmlns="http://www.opengis.net/ogc">
<PropertyIsEqualTo matchCase="true">
<PropertyName>dirct_gen_code</PropertyName>
<Literal>43</Literal>
</PropertyIsEqualTo>
</Filter>&
CRS=EPSG:3857&
STYLES=&
WIDTH=1297&
HEIGHT=970&
BBOX=-7907987.59608382%2C5928571.109639037%2C-7901791.419478454%2C5933205.104478827

I don't have any exposed service for test purposes...

Thanks

Pierre
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20220602/f91b9a81/attachment.htm>