<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Hi list,</div>
<div> </div>
<div>until now I've been<b> using mapserver 4.10.2 </b>for generating wfs (for use with wfs-gazetteers). I determined the order of the wfs-output with the ORDER BY clause of the DATA-statement.</div>
<div> </div>
<div>Example:</div>
<div>DATA 'the_geom from (SELECT the_geom, fid, str_name, haus_nr, haus_nr_zusatz, str_such_string, ... FROM stgk_hausnummern ORDER BY str_name,haus_nr,haus_nr_zusatz) as foo using unique fid using SRID=31468'</div>
<div> </div>
<div>The result:</div>
<div> </div>
<div> </div>
<div> </div>
<div>Changing the ORDER BY - clause caused changing the sort order of the output.</div>
<div> </div>
<div>==============================================================</div>
<div> </div>
<div><b>Using mapserver 5.2.0 and mapserver 5.2.1 </b>the ORDER BY - clause has obviously no effect. The wfs - output is <b>always</b> sorted by sort order given from attribute <b>fid</b>. </div>
<div>Fid is the feature-id and implemented in the database as a unique-constraint. </div>
<div> </div>
<div>Is it possible to change the sort order in mapserver 5.x.x too?</div>
<div>Has anybody a tipp for me, how this could be done ?</div>
<div> </div>
<div>Thanks</div>
<div> </div>
<div>Schoenhammer Herbert</div>
<div> </div>
<div>P.S.</div>
<div> </div>
<div>The generated urls are looking like:</div>
<div><a href="http://myserver/cgi-bin/getows?map=/data-umn/wfs/rgb_wfs_adressen.map&REQUEST=getFeature&Typename=adressen&Version=1.0.0&service=WFS&filter=%3Cogc:Filter+xmlns:ogc=%27http://ogc.org%27+xmlns:gml=%27http://www.opengis.net/gml%27%3E%3Cogc:PropertyIsLike+wildCard=%27*%27+singleChar=%27.%27+escape=%27!%27%3E%3Cogc:PropertyName%3Estr_such_string%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*MARTIN*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E"><font color="#0000FF"><u>http://myserver/cgi-bin/getows?map=/data-umn/wfs/rgb_wfs_adressen.map&REQUEST=getFeature&Typename=adressen&Version=1.0.0&service=WFS&filter=%3Cogc:Filter+xmlns:ogc=%27http://ogc.org%27+xmlns:gml=%27http://www.opengis.net/gml%27%3E%3Cogc:PropertyIsLike+wildCard=%27*%27+singleChar=%27.%27+escape=%27!%27%3E%3Cogc:PropertyName%3Estr_such_string%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*MARTIN*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E</u></font></a></div>
<div> </div>
<div> </div>
<div> </div>
</font>
</body>
</html>