[mapguide-users] Sql For Data Filter

[ary sucaya]

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" <ks at geograf.dk>
To: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
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
mapguide-users at lists.osgeo.org
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080101/6a81fb7a/attachment.html