[mapguide-users] Sql For Data Filter

[Kenneth, GEOGRAF A/S]

Yes, that is what the "Ad Hoc Queries" does.

Perhaps you want to combine it with "Dynamic Themes"?

Regards, Kenneth, GEOGRAF A/S



ary sucaya skrev:
> Thanks Kenneth,
>  
> I'm looking for sample code of making data filter programmatically and 
> save in into current session.
>  
>  
>  
> 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 10:08:48 AM
> Subject: Re: [mapguide-users] Sql For Data Filter
>
> 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
>>   
>
>
> ------------------------------------------------------------------------
> 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
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080102/913e3a7b/attachment.html