<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" size="2">
<div>Hi list, </div>
<div> </div>
<div>I have posted this item some days ago, but I didn't get some help. So I want to repeat my question:</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>Changing the ORDER BY - clause caused changing the sort order of the output. </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>. (could be another attribute like oid, but it is alwas used the attribute
after USING UNIQUE ..)</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>Schoenhammer Herbert </div>
<div> </div>
<div>P.S. </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><font face="Arial, sans-serif"> </font></div>
</font>
</body>
</html>