<!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">
I don't have a list of what the different providers support.<br>
I have used the OGR provider, and it supports PostGIS and limited SQL.<br>
<br>
My approach to your problem would be to start out with the layer hidden.<br>
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.<br>
Then you update the filter on the layer to reflect this:<br>
GeoColumn Intersects GEOMFROMTEXT('....wkt....')<br>
Then show the layer.<br>
<br>
You should copy the layer into the session repository before altering
it.<br>
If you want to theme it, you can create multiple copies of the layer
and apply theming to the individual layers.<br>
<pre class="moz-signature" cols="72">Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
<br>
ary sucaya skrev:
<blockquote cite="mid:980051.61686.qm@web58609.mail.re3.yahoo.com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Thank
for your reply,</div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;"> </div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Can
you pls inform me what provider support full sql syntax? I use postgis
and it seem to be not support full sql syntax.</div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">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.<br>
</div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Regards,</div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;"> </div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Ary
Sucaya</div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;"><br>
</div>
<div
style="font-size: 12pt; font-family: times new roman,new york,times,serif;">-----
Original Message ----<br>
From: "Kenneth, GEOGRAF A/S" <a class="moz-txt-link-rfc2396E" href="mailto:ks@geograf.dk"><ks@geograf.dk></a><br>
To: MapGuide Users Mail List <a class="moz-txt-link-rfc2396E" href="mailto:mapguide-users@lists.osgeo.org"><mapguide-users@lists.osgeo.org></a><br>
Sent: Tuesday, January 1, 2008 5:25:05 PM<br>
Subject: Re: [mapguide-users] Sql For Data Filter<br>
<br>
That depends on the provider. Some providers supports full SQL syntax.<br>
<br>
I can't see how you can join tables with a filter, as that is the
equvalent of the SQL WHERE construct.<br>
You can try to setup a Join on the featuresource, but I have had
limited success with joins.<br>
<pre class="moz-signature">Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
<br>
ary sucaya skrev:
<blockquote type="cite">
<div
style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">
<div>Hello,</div>
<div> </div>
<div>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.</div>
<div> </div>
<div> </div>
<div>Regs,</div>
<div> </div>
<div>ary sucaya</div>
</div>
<br>
<hr size="1">
Never miss a thing. <a moz-do-not-send="true"
href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"
target="_blank" rel="nofollow">Make Yahoo your homepage.</a>
<pre><hr size="4" width="90%">
_______________________________________________
mapguide-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:mapguide-users@lists.osgeo.org" target="_blank"
rel="nofollow" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target="_blank" rel="nofollow">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
</div>
<div style="font-size: 10pt; font-family: arial,helvetica,sans-serif;"><br>
</div>
</div>
<br>
<hr size="1">Looking for last minute shopping deals? <a
moz-do-not-send="true"
href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
</body>
</html>