[mapserver-users] Order of attributes returned from WFS GetFeature

[Dejan Gambin]

Thanks,

I tried something like:

DATA "the_geom from (select the_geom, attr1, attr2 from table) as new_table using unique gid"

but this doesn't work. Can you tell me how should such a query look like? Now it is like:

DATA "the_geom from table using unique gid"

Thanks very much

regards, dejan
On 27. pro. 2011., at 22:13, Rahkonen Jukka wrote:

> Hi,
> 
> The WFS standard defines that attributes are included in a XML sequence. Therefore the returned attributes must be in the same order than in the schema of your feature type.
> 
> I would suggest also having a try with editing the SQL in the DATA line and selecting attributes as you like but check first if it has an effect on the schema returned by DescribeFeatureType.
> 
> -Jukka Rahkonen-
> ________________________________________
> Lime, Steve D (DNR) wrote:
> 
>> I don't believe you can control this on the MapServer side. Why not just set the column order
>> explicitly in the SQL statement?
> 
>> Steve
> 
>> -----Original Message-----
>> From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf > Of Dejan Gambin
>> Sent: Thursday, December 22, 2011 7:40 AM
>> To: mapserver-users at lists.osgeo.org
>> Subject: [mapserver-users] Order of attributes returned from WFS GetFeature
> 
>> Hi,
> 
>> I am using GetFeature request to get the attributes from my PostGIS data. I define attributes with "gml_include_items". The order of attributes is however related to postgis column order, not to the order in gml_include_items.
> 
> Is it somehow possible to change the order, withoout need to modify column order in PostGIS/PostgreSQL?
> 
> regards, dejan_______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users