[mapguide-users] MapGuide SQL2008 Provider: can't support
carlshe at 163.com
Mon Oct 20 05:08:12 EDT 2008
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
>>> and had my problem partially resolved.
>>> Now I can add a layer referencing to a feature datasource of ms sql
>>> 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
>>> 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
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.
More information about the mapguide-users