Thanks. This works like a charm :-) dejan On 29. pro. 2011., at 12:40, Havard Tveite wrote:
> 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 _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
