<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
There exists an FDO command that allows you you to pass the query
directly to the datasource.<br>
AFAIK, that is not possible to do with a layer filter.<br>
<br>
Instead, you can create a view in the database with the appropriate
filter, and then use that view as your datasource.<br>
<pre class="moz-signature" cols="72">Regards, Kenneth Skovhede, GEOGRAF A/S
</pre>
<br>
<br>
Carl skrev:
<blockquote cite="mid:20056615.post@talk.nabble.com" type="cite">
<pre wrap="">
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:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>