[mapguide-users] Sql For Data Filter

[Kenneth, GEOGRAF A/S]

I think the "Query" part of the "Generic Tasks" is close to what you want:
http://data.mapguide.com/mapguide/gt/index.php

More samples:
http://mapguide.osgeo.org/livegallery.html

Regards, Kenneth, GEOGRAF A/S



ary sucaya skrev:
> Great!, I will try
> I was wondering if there is a sample code for it..
> Thank v much..
>  
> 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: Wednesday, January 2, 2008 8:46:05 AM
> Subject: Re: [mapguide-users] Sql For Data Filter
>
> 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
>>   
>
>
> ------------------------------------------------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try 
> it now. 
> <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20> 
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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/e08502ea/attachment.html