[mapguide-users] Sql For Data Filter

[Kenneth, GEOGRAF A/S]

I don't have a list of what the different providers support.
I have used the OGR provider, and it supports PostGIS and limited SQL.

My approach to your problem would be to start out with the layer hidden.
When you want to display the correct district, you read out the WKT of 
the feature (district) you want to perform the intersection test with.
Then you update the filter on the layer to reflect this:
GeoColumn Intersects GEOMFROMTEXT('....wkt....')
Then show the layer.

You should copy the layer into the session repository before altering it.
If you want to theme it, you can create multiple copies of the layer and 
apply theming to the individual layers.

Regards, Kenneth, GEOGRAF A/S



ary sucaya skrev:
> 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. 
>> <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> 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://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping> 
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080102/2cbd0a12/attachment.html