<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:CourierNewPSMT;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Max,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>When you have join of SDF to SQL Server feature source, you can
only define a filter for the fields from the primary source of the join (i.e.
the properties in the SDF). It is not currently possible to setup a
filter for the secondary feature source of a join (i.e. the SQL Server datasource
properties). Depending on what you a trying to achieve, you may be able
to get similar desired result by setting up an appropriate theme based on the
properties from the secondary feature source.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ronnie<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Rahul
[mailto:unicorn_admirer@yahoo.com] <br>
<b>Sent:</b> Thursday, September 06, 2007 3:27 AM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> [mapguide-users] SDF & SQL Server 2005 Joined Feature
Source<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>Hi All,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> I
tried to join the SDF faeture source spatial data with the SQL Server 2005
Views(non spatial data) ,I manage to get the new joined feature source and
get the attributes in the property pane but i stuck in the Search
criteria and when i tried to search the joined feature class using the
filter like -<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>$filter ="LU_STATUS = '" . $status
."'"." and " . "PD_GROUP=
'".$group."'"." and " . "SHAREHOLDE=
'".$share."'"." or " . "PROMOTION=
'".$plan."'";<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'>$queryOptions
= new MgFeatureQueryOptions();<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'>$queryOptions->SetFilter($filter);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"CourierNewPSMT","serif"'>I unable
to get any values and it use to give no search found.Can anybody help me
regarding this issue and where i can get some detail for working with SQL
commands on the feature source ,i tried in the mapagent some basic sql commands
but it use to give error and i cannot find the way to go with them.</span><span
style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"CourierNewPSMT","serif"'>Max<o:p></o:p></span></p>
<div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
</div>
<p> <o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p class=MsoNormal>Yahoo! oneSearch: Finally, <a
href="http://us.rd.yahoo.com/evt=48252/*http:/mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC">mobile
search that gives answers</a>, not web links. <o:p></o:p></p>
</div>
</body>
</html>