I think your subselect has to include gid.
Examples on:
<URL: http://mapserver.org/input/vector/postgis.html#data-access-connection-method
>
Håvard
On 12/29/2011 12:19 PM, Dejan Gambin wrote:
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: [email protected]
[mailto:[email protected]] On Behalf> Of Dejan Gambin
Sent: Thursday, December 22, 2011 7:40 AM
To: [email protected]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Håvard Tveite
Department of Mathematical Sciences and Technology, UMB
Drøbakveien 31, POBox 5003, N-1432 Ås, NORWAY
Phone: +47 64965483 Fax: +47 64965401 http://www.umb.no/imt/
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
