Hi Julien,
> 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
I think that you have a database design problem.
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.
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.
IC Carlos Ruiz
________________________________
From: Julien Cigar <jci...@ulb.ac.be>
To: Carlos Ruiz <boolean10...@yahoo.com>
Cc: "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org>
Sent: Wednesday, February 1, 2012 2:59 AM
Subject: Re: [mapserver-users] PostGIS query
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.
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users