[mapguide-users] MapGuide SQL2008 Provider: can't support geometry method?

[Carl]

Is it possible for MG Server to Parse the Filter dynamically, i.e. the
filter can act as request parameter?

I think it will be very useful.


Kenneth Skovhede, GEOGRAF A/S wrote:
> 
> There exists an FDO command that allows you you to pass the query 
> directly to the datasource.
> AFAIK, that is not possible to do with a layer filter.
> 
> Instead, you can create a view in the database with the appropriate 
> filter, and then use that view as your datasource.
> 
> Regards, Kenneth Skovhede, GEOGRAF A/S
> 
> 
> 
> Carl skrev:
>> I got it partially.
>>
>> C:\Program Files\MapGuideOpenSource2.0\WebServerExtensions\Help\index.htm
>>
>> I set the filter as:
>>
>> Prj_Geometry INTERSECTS GEOMFROMTEXT ( 'POINT(1 1)' )
>>
>> But sometimes the complicated spatial computation can only be done by the
>> datasource self. Maybe it is possible to add a bool tag to denote how to
>> parse the filter? by the provider or by MG OS Server?
>>
>>
>> Carl wrote:
>>   
>>> I just had a post about SQL 2008 Provider and got many effective
>>> answers,
>>> and had my problem partially resolved.
>>>
>>> Now I can add a layer referencing to a feature datasource of ms sql
>>> 2008. 
>>>
>>> Further more, I need to give a filter to the layer to select part of
>>> features. if I give a common condition(i.e. the common boolean clause,
>>> such as " id='1' and name like '%_c' "), and the mapguide can give a
>>> correct response (i.e. the features on the map are just those selected).
>>> but if I give a spatial condition ( such as "Prj_Geometry.STIsClosed()=1
>>> "), Mapguide always return a map contains all features.
>>>
>>> Is the boolean expression parsed by the datasource or by MapGuide Server
>>> itself? 
>>>
>>> In my opinion, the filter string should be parsed and executed by the
>>> provider datasource, such as MS SQL server 2008.
>>>
>>> could anybody help me?
>>>
>>>     
>>
>>   
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/MapGuide-SQL2008-Provider%3A-can%27t-support-geometry-method--tp20056020p20065743.html
Sent from the MapGuide Users mailing list archive at Nabble.com.