The presentation side of the WFS code doesn't do any sorting so that's not the culprit. Looks like you're using PostGIS. Is there any way you can capture the SQL actually being generated by MapServer and executed by PostGIS? That would help us track this down.
Steve >>> On 12/16/2008 at 4:13 AM, in message <d1982c7c00c1de409dde5f9ab94c9e6aac269a4...@mail-back01.regensburg.de>, Schönhammer, Herbert <[email protected]> wrote: > Hi list, > > I have posted this item some days ago, but I didn't get some help. So I want > to repeat my question: > > Until now I've been using mapserver 4.10.2 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. > > Example: > 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' > > Changing the ORDER BY - clause caused changing the sort order of the output. > ============================================================== > > Using mapserver 5.2.0 and mapserver 5.2.1 the ORDER BY - clause has obviously > no effect. The wfs - output is always sorted by sort order given from > attribute fid. (could be another attribute like oid, but it is alwas used the > attribute after USING UNIQUE ..) > > Is it possible to change the sort order in mapserver 5.x.x too? > Has anybody a tipp for me, how this could be done ? > > Thanks > Schoenhammer Herbert > > P.S. > The generated urls are looking like: > http://myserver/cgi-bin/getows?map=/data-umn/wfs/rgb_wfs_adressen.map&REQUEST=g > etFeature&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:Pr > opertyName%3Estr_such_string%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*MARTIN*% > 3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
