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 <jci...@ulb.ac.be>
To: "mapserver-users@lists.osgeo.org" <mapserver-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to