[mapserver-users] PostGIS query

[Carlos Ruiz]

Julien,

Have you tried with views ? When I need to map complex queries I build a view to just handle the where clauses.

Cheers from México

 
IC Carlos Ruiz



________________________________
 From: Julien Cigar <jcigar at ulb.ac.be>
To: "mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org> 
Sent: Tuesday, January 31, 2012 6:38 AM
Subject: [mapserver-users] PostGIS query
 
Hello,

Is there a way to (deeply) modify the SQL query in a PostGIS layer?
I would like to add some JOIN, additional WHERE clauses, etc
As I'm afraid that "Run-time Substitution" isn't flexible enough for this case ... is there any other possibility, other than mapscript?

I guess there is no possibility to define variables, conditions, etc in a .map file .. ?

Thanks,
Julien

-- No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120131/dd4d61dd/attachment-0001.html