[mapserver-users] RE [Polluriel potentiel] Re: RE null value renders in pie chart SOLVED

[Steve.Toutant at inspq.qc.ca]

I'm using 6.1, these 2 solutions work!
preprocess your data to replace NULLs by 0, or use a DATA statement on a 
postgis layer to do that for you ( e.g. DATA "the_geom from (select gid, 
the_geom, COALESCE(cri,0) AS cri from mytable) as foo using uninque gid" )

Thank you for your fantastic help,
Steve





thomas bonfort <thomas.bonfort at gmail.com> 
2013-01-03 13:18

A
Steve.Toutant at inspq.qc.ca
cc
MapserverList OSGEO <mapserver-users at lists.osgeo.org>, 
mapserver-users-bounces at lists.osgeo.org
Objet
[Polluriel potentiel]  Re: [mapserver-users] RE null value renders in pie 
chart








Note that EXPRESSION support was added to pie layers in 6.2 only. I'd say 
your best bet is to preprocess your data to replace NULLs by 0, or use a 
DATA statement on a postgis layer to do that for you ( e.g. DATA "the_geom 
from (select gid, the_geom, COALESCE(cri,0) AS cri from mytable) as foo 
using uninque gid" )

--
thomas


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130103/c00f042b/attachment.htm>