Thank for your reply,
Can you pls inform me what provider support full sql syntax? I use postgis and
it seem to be not support full sql syntax.
In my case, i can't use join tables because i need spatial relationship between
2 tables. For examples in Mapguide sample there are 11 districts. At first
time, i want to hide parcels. Then i want to make a query to show parcels in
particular distric and i want maps show parcels which are in that query result.
In this case, join between two tables may not help me. I make use spatial
relationship such as intersects or within in this case.
Regards,
Ary Sucaya
----- Original Message ----
From: "Kenneth, GEOGRAF A/S" <[EMAIL PROTECTED]>
To: MapGuide Users Mail List <[email protected]>
Sent: Tuesday, January 1, 2008 5:25:05 PM
Subject: Re: [mapguide-users] Sql For Data Filter
That depends on the provider. Some providers supports full SQL syntax.
I can't see how you can join tables with a filter, as that is the equvalent of
the SQL WHERE construct.
You can try to setup a Join on the featuresource, but I have had limited
success with joins.
Regards, Kenneth, GEOGRAF A/S
ary sucaya skrev:
Hello,
I was wondering if i can put a complex sql statement at 'Filter applied to
data' textbox on Layer Editor. I need to show some data from my postgis table
and sql to select this data involving 2 or more table.
Regs,
ary sucaya
Never miss a thing. Make Yahoo your homepage.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
