Hi Michaël: What version are you using? There were some fixes related to rendering queries in the latest 7.4 release.<div><br></div><div>—Steve<br><br>On Friday, January 17, 2020, Kalbermatten Michaël <<a href="mailto:Michael.Kalbermatten@ne.ch">Michael.Kalbermatten@ne.ch</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="FR-CH" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal"><span lang="EN-US">Dear all,</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">We have quite a strange filter behavior.</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">We have a layer (relying on PostGIS data and with multine geometries) containing several classes with some of them having multiple STYLE tags. Something like:</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">CLASS</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "Ouvrages d'art"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> EXPRESSION "Ouvrages d'art"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 255 141 0</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WIDTH 8</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">CLASS</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "OFROU"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> EXPRESSION "OFROU"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 255 0 0</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WIDTH 8</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 255 141 0</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WIDTH 2</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">CLASS</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "CFF"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> EXPRESSION "CFF"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 35 35 35</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WIDTH 3</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 35 35 35</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> SYMBOL "barre"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> SIZE 12</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> GAP -10</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">A WMS request on this layer will renderer all objects regarding their class, which is the expected behavior.</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Now, a FILTER tag is applied on this layer, a request which would look like:</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><a href="http://myserver.com/my_mapserver_cgi?SERVICE=WMS" target="_blank">http://myserver.com/my_<wbr>mapserver_cgi?SERVICE=WMS</a></span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&VERSION=1.3.0</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&REQUEST=GetMap</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&FORMAT=image/png</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&TRANSPARENT=true</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&LAYERS=rt55_chantiers_futurs</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&STYLES=</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB">&FILTER=(<Filter xmlns="</span><span lang="DE-CH"><a href="http://www.opengis.net/ogc" target="_blank"><span lang="EN-GB">http://www.opengis.net/<wbr>ogc</span></a></span><span lang="EN-GB">"><PropertyIsBetween><<wbr>PropertyName>annee_debut</<wbr>PropertyName><LowerBoundary><<wbr>Literal>2021</Literal></<wbr>LowerBoundary><UpperBoundary><<wbr>Literal>2021</Literal></<wbr>UpperBoundary></<wbr>PropertyIsBetween></Filter>)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&CRS=EPSG:2056</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&WIDTH=1925</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&HEIGHT=936</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">&BBOX=2503325,1194925,2599575,<wbr>1222975</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">(I removed the URL escaping and made it multiline for readability)</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">This request generates something really strange. Returned features from the server are rendered until Mapserver encounters the first feature which corresponds to a class having more than one STYLE tag. All other features
(coming next regarding the request sent to the PostGIS server) are not rendered any more. Mapserver does not trigger any error, nor does the database. In the mapserver logs:</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].640000 CGI Request 1 on process 4228</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].649000 FLTLayerApplyPlainFilterToLaye<wbr>r(): ("[annee_debut]" ~* ".*2021.*"), rect=2503325,1194925,2599575,<wbr>1222975</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].658000 msDrawMap(): rendering using outputformat named png (AGG/PNG).</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].658000 msDrawMap(): WMS/WFS set-up and query, 0.000s</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].658000 msDrawMap(): Layer 917 (rt55_chantiers_futurs), 0.000s</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].658000 msDrawMap(): Drawing Label Cache, 0.000s</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].658000 msDrawMap() total time: 0.003s</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].709000 msSaveImage(stdout) total time: 0.051s</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].709000 mapserv request processing time (msLoadMap not incl.): 0.069s</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Wed Jan 15 08:03:11 2020].709000 msFreeMap(): freeing map at 00000258E99A8030.</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">After playing with the Mapfile and related data for a few hours, we discovered that because we analyzed the following elements :
</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> - The feature order in the database</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> - The STYLE tags in the mapfile classes: making all classes having only one STYLE tag</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Thus, if a use these classes:</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal">CLASS<u></u><u></u></p>
<p class="MsoNormal"> NAME "Ouvrages d'art"<u></u><u></u></p>
<p class="MsoNormal"> EXPRESSION "Ouvrages d'art"<u></u><u></u></p>
<p class="MsoNormal"> <span lang="EN-GB">STYLE<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"> COLOR 255 141 0<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"> WIDTH 8<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">CLASS</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "OFROU"</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> EXPRESSION "OFROU"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 255 0 0</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WIDTH 8</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">CLASS</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "CFF"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> EXPRESSION "CFF"</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 35 35 35</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WIDTH 3</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LINECAP butt</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Then everything works as expected (using a filter tag in the request), and all features are rendered by Mapserver.</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Moreover it is not a DB issue, because if you send a WFS request using exactly the same layer definition and the same filter to Mapserver, then everything is working as expected (all expected features are returned).</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">This really looks like some kind of rendering issue combined to filtering.</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Any hints or thoughts on that ?</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal">Best regards<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Michael<u></u><u></u></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
</div>
</div>
</blockquote></div>