[mapserver-users] Again: WFS: How to sort the WFS output in MS 5.x.x ?

[Schönhammer, Herbert]

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=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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081216/635d2d9c/attachment.htm>