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

[Steve Lime]

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
<D1982C7C00C1DE409DDE5F9AB94C9E6AAC269A4107 at mail-back01.Regensburg.de>,
Schönhammer, Herbert <Schoenhammer.Herbert at Regensburg.de> 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