[Geomoose-users] feature_report data sources

[Brent Fraser]

Paul,

   i think you need to use the DATA statement to ensure all the 
attributes are retrieved.  Here's an example:

         DATA 'wkb_geometry from (select id as feature_id, attribute1, 
attribute2, astext(wkb_geometry) as wkt_geometry, wkb_geometry from 
test_points) as mytable using unique feature_id'

Best Regards,
Brent Fraser

On 11/27/2014 9:38 AM, R. Paul Warriner wrote:
> Thank you for the responses Raffaele and Brent.
>
> The layer is good, I have all the features for the layer showing up, and
> identify works fine showing appropriate attributes, but when trying to run a
> Report or Search Parcels, I get errors from feature_report.php or query.php
> respectively.
>
> When I change the mapfile data source from PG to shapefile, the report and
> query options work fine, but not under PG.
>
>    	LAYER
> 		CONNECTIONTYPE postgis
> 		NAME parcels
> 		#DATA './parcels.shp'
> 		CONNECTION "host=xxxx dbname=xxxxx port=xxxx user=xxxxx
> password=xxxxx"
> 	 	DATA "geom from parcel_poly_geomoose"
> 		GROUP parcels_group
> 		STATUS ON
> 		TYPE POLYGON
> 		LABELITEM 'sbl'
> 		LABELCACHE ON
> 		LABELMAXSCALE 20000
> 		# FILTER ([PARC_CODE] == 1)
> 		CLASS
> 		.....
>
> -----Original Message-----
> From: geomoose-users-bounces at lists.osgeo.org
> [mailto:geomoose-users-bounces at lists.osgeo.org] On Behalf Of Raffaele
> Morelli
> Sent: Thursday, November 27, 2014 10:07 AM
> To: geomoose-users at lists.osgeo.org
> Subject: Re: [Geomoose-users] feature_report data sources
>
> On 27/11/14 at 09:40am, R. Paul Warriner wrote:
>> Hello,
>>
>>   
>>
>> New to GeoMoose.
>>
>> Can only shapefiles be used for the feature_report, as I am getting
>> script errors when switching to a PostGIS layer?
>>
>>   
>>
>> Regards,
>> Paul
> Feature_report is mapfile dependent, no matter what datasource you are
> using.
> And if you are getting errors on a PostGIS layer... there you go.
>
> Check your mapfile with:
> shp2img -m path/to/your/mapfile -l layername_here -all_debug 3
>
> see shp2img --help for other debug options
>
>
> --
> My mama said
> to get things done
> You'd better not mess
> with Major Tom
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>