Thanks for the tip, Ian! In GS v.2.20.4 I see the following error: «Filter function problem for function int2ddouble argument #0 — expected type int» Changed a bit to this: <ogc:Filter> <ogc:PropertyIsEqualTo> <ogc:Function name="IEEERemainder"> <ogc:PropertyName>propertyVa</ogc:PropertyName> <ogc:Literal>20.0</ogc:Literal> </ogc:Function> <ogc:Literal>0</ogc:Literal> </ogc:PropertyIsEqualTo> </ogc:Filter> And it worked! >Среда, 20 марта 2024, 12:02 +02:00 от Ian Turton <ijtur...@gmail.com>: > >You'll want the `IEEERemainder` function documented on the Filter Function >Reference page ( >https://docs.geoserver.org/latest/en/user/filter/function_reference.html#math-functions > ) - > > <ogc:Filter> > <ogc:PropertyIsEqualTo> > <ogc:Function name="IEEERemainder"> > <ogc:Function name="int2ddouble"> > <ogc:PropertyName>propertyVa</ogc:PropertyName> > </ogc:Function> > <ogc:Literal>20.0</ogc:Literal> > </ogc:Function> > <ogc:Literal>0</ogc:Literal> > </ogc:PropertyIsEqualTo> > </ogc:Filter> > > >Ian > >On Wed, 20 Mar 2024 at 08:13, Ярослав Минин via Geoserver-users < >geoserver-users@lists.sourceforge.net > wrote: >>Hello community! >> >>I’ve got troubles with filter expression. I have an integer column with >>values, like 2, 5, 30, 100… >>And I need to filter those divisible by 25, for instance. >> >>Since I’m currently unable to manipulate the DB (to create the views for I >>need) the only option is sld-filtering. Is there any way to achieve this? >> >>-- >>Regards, >>Yaras _______________________________________________ >>Geoserver-users mailing list >> >>Please make sure you read the following two resources before posting to this >>list: >>- Earning your support instead of buying it, but Ian Turton: >>http://www.ianturton.com/talks/foss4g.html#/ >>- The GeoServer user list posting guidelines: >>http://geoserver.org/comm/userlist-guidelines.html >> >>If you want to request a feature or an improvement, also see this: >>https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer >> >> >>Geoserver-users@lists.sourceforge.net >>https://lists.sourceforge.net/lists/listinfo/geoserver-users > >-- >Ian Turton -- С уважением, Ярослав Минин
_______________________________________________ Geoserver-users mailing list
Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
