<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Julien,</span></div><div><br><span></span></div><div><span>Have you tried with views ? When I need to map complex queries I build a view to just handle the where clauses.</span></div><div><br><span></span></div><div><span>Cheers from México</span></div><div> </div><div><font style="font-weight:bold;color:rgb(0, 96, 191);font-family:verdana, helvetica, sans-serif;" size="2">IC Carlos Ruiz</font><br><br></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Julien Cigar <jcigar@ulb.ac.be><br> <b><span style="font-weight: bold;">To:</span></b> "mapserver-users@lists.osgeo.org"
<mapserver-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, January 31, 2012 6:38 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] PostGIS query<br> </font> </div> <br>
Hello,<br><br>Is there a way to (deeply) modify the SQL query in a PostGIS layer?<br>I would like to add some JOIN, additional WHERE clauses, etc<br>As I'm afraid that "Run-time Substitution" isn't flexible enough for this case ... is there any other possibility, other than mapscript?<br><br>I guess there is no possibility to define variables, conditions, etc in a .map file .. ?<br><br>Thanks,<br>Julien<br><br>-- No trees were killed in the creation of this message.<br>However, many electrons were terribly inconvenienced.<br><br>_______________________________________________<br>mapserver-users mailing list<br><a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br><br><br> </div> </div> </div></body></html>