On 01/31/2012 17:05, Carlos Ruiz wrote:
Julien,
Hi Carlos,
Have you tried with views ? When I need to map complex queries I build a view to just handle the where clauses.
I usually use a view, but in this case there are a lot of tables involved and I would like to avoid dozens of unnecessary JOIN
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 <mailto:mapserver-users@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-- No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced.
<<attachment: jcigar.vcf>>
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users