<!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">
You need to modify the layer's filter property.<br>
You should consider the datasource, a complete unit, such as a
datatable or a spatial file. Since this source can be used in multiple
layer, filtering it would possibly render it useless for other layers.<br>
The layer, however, can easily be an extract of the datasource.<br>
<br>
If you want to do this on a per-user basis, you need to grab the map
that the user is currently seeing, through the resource service, and
modify the layer, and then save it back.<br>
You may of course want to create it on the fly, instead of modifying an
exsiting one. Any changes saved to the session map, has effect in that
session only.<br>
<pre class="moz-signature" cols="72">Regards Kenneth, GEOGRAF
</pre>
<br>
<br>
Bill MacDonald skrev:
<blockquote
cite="midA91726338CEF00469AC9CF0D486FA7229424ED@agmain.agresearch.ca"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"
style="margin-bottom: 12pt; line-height: 11.25pt;"><font face="Arial"
size="2"><span style="font-size: 10pt; font-family: Arial;">Hi,<br>
I have a map with a layer that is being populated from x/y coordinates
from an
SQL server table and want to be able to dynamically add a filter to the
layer.
Ie filter the data based on who is logged in. <o:p></o:p></span></font></p>
<p class="MsoNormal"
style="margin-bottom: 12pt; line-height: 11.25pt;"><font face="Arial"
size="2"><span style="font-size: 10pt; font-family: Arial;">I had
found
a few articles on how to dynamically select the items, but have been
unable to
find anything about filtering the data returned by server.<o:p></o:p></span></font></p>
<p class="MsoNormal"
style="margin-bottom: 12pt; line-height: 11.25pt;"><font face="Arial"
size="2"><span style="font-size: 10pt; font-family: Arial;">I could
easily do this in Mapguide 6.5 by specifiying the SQLWhere on a layer,
but it
seems that it is not quite so straightforward with the new version.<br>
<br>
<o:p></o:p></span></font></p>
<p class="MsoNormal"
style="margin-bottom: 12pt; line-height: 11.25pt;"><font face="Arial"
size="2"><span style="font-size: 10pt; font-family: Arial;">Any
information on how to do this would be greatly appreciated. <br>
<br>
Thanks <br>
<br>
Billy <o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
</body>
</html>