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

[Kenneth Skovhede, GEOGRAF A/S]

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?
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20081020/5f802126/attachment.html