<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div>Hi Julien,<br></div><div><br></div><div>> I usually use a view, but in this case there are a lot of tables <br>> involved and I would like to avoid dozens of unnecessary JOIN<br></div><div><br></div><div>I think that you have a database design problem.</div><div><br></div><div>You can have a lot of tables which concerns to a different objects, but you need to show some information on a map which involves many of those tables. That's why you have to create different views or in the worst case, a super view as a spreadsheet.</div><div><br></div><div>I guess that's why you're talking about unnecessary JOINs, but in the end, you'll need to use them to create the multiple data sources or the super data source of your layers in the .MAP file.<br></div><br><div><font class="yui_3_2_0_17_132828563829552" style="font-weight: bold; color:
rgb(0, 96, 191); font-family: verdana,helvetica,sans-serif;" size="2"><br></font></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> Carlos Ruiz <boolean10001@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, February 1, 2012 2:59 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [mapserver-users] PostGIS query<br>
</font> </div> <br>
On 01/31/2012 17:05, Carlos Ruiz wrote:<br>> Julien,<br><br>Hi Carlos,<br><br>><br>> Have you tried with views ? When I need to map complex queries I build a<br>> view to just handle the where clauses.<br>><br><br>I usually use a view, but in this case there are a lot of tables <br>involved and I would like to avoid dozens of unnecessary JOIN<br><br>> Cheers from México<br>> IC Carlos Ruiz<br>><br>> ------------------------------------------------------------------------<br>> *From:* Julien Cigar <<a ymailto="mailto:jcigar@ulb.ac.be" href="mailto:jcigar@ulb.ac.be">jcigar@ulb.ac.be</a>><br>> *To:* "<a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>" <<a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>> *Sent:* Tuesday, January 31, 2012 6:38
AM<br>> *Subject:* [mapserver-users] PostGIS query<br>><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<br>> this case ... is there any other possibility, other than mapscript?<br>><br>> I guess there is no possibility to define variables, conditions, etc in<br>> 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> <mailto:<a
ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>><br>><br><br><br>-- <br>No trees were killed in the creation of this message.<br>However, many electrons were terribly inconvenienced.<br><br><br> </div> </div> </div></body></html>