[MapServer-users] converting an expression to an OGC filter

[Ian Turton]

On Thu, 1 Dec 2022 at 22:13, Lime, Steve D (MNIT) <steve.lime at state.mn.us>
wrote:

> Hi Ian: What’s the backend (e.g. shapefile, PostGIS, etc…)? MapServer
> expressions don’t support a wildcard operator (outside of a regex) so I’m
> not sure off the top of my head and things may vary by driver.
>

It's a postgis database on the backend, the original expression works fine
but not when it's input as an OGC expression.

Ian

>
>
> --Steve
>
>
>
> *From:* MapServer-users <mapserver-users-bounces at lists.osgeo.org> *On
> Behalf Of *Ian Turton
> *Sent:* Thursday, December 1, 2022 9:50 AM
> *To:* mapserver-users at lists.osgeo.org
> *Subject:* [MapServer-users] converting an expression to an OGC filter
>
>
>
> I currently have an expression in my mapfile EXPRESSION ('[postcode]' ~*
> '0..$') and I'm in the process of moving to using SLD for styling - I
> thought I could convert that expression to
>
>
>
>      <PropertyIsLike wildcard="*" singleChar="." escapeChar="\" matchCase="false">
>
>         <PropertyName>postcode</PropertyName>
>
>         <Literal>.*0..</Literal>
>
>       </PropertyIsLike>
>
> Which I think should match from the start of the string (.*) to a 0 and then two characters (..) to the end of the string. But it doesn't work - neither does any variant on this work either.
>
> Is there some issue with conversions between SLD Filters and internal expressions that I'm missing or is there something else I should know about LIKE filters?
>
> Thanks
>
>
>
> Ian
>
> --
>
> Ian Turton
>


-- 
Ian Turton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20221202/d3aefd57/attachment.htm>