[mapguide-users] SDF & SQL Server 2005 Joined Feature Source

[Ronnie Louie]

Hi Max,

 

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.

 

Ronnie

 

 

From: Rahul [mailto:unicorn_admirer at yahoo.com] 
Sent: Thursday, September 06, 2007 3:27 AM
To: MapGuide Users Mail List
Subject: [mapguide-users] SDF & SQL Server 2005 Joined Feature Source

 

Hi All,

          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 -

 

$filter ="LU_STATUS = '" . $status ."'"." and " . "PD_GROUP=
'".$group."'"." and " . "SHAREHOLDE= '".$share."'"." or " . "PROMOTION=
'".$plan."'";

 

$queryOptions = new MgFeatureQueryOptions();

$queryOptions->SetFilter($filter);

 

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.

 

Thanks

Max



 

  

  _____  

Yahoo! oneSearch: Finally, mobile search that gives answers
<http://us.rd.yahoo.com/evt=48252/*http:/mobile.yahoo.com/mobileweb/ones
earch?refer=1ONXIC> , not web links. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070906/1872520a/attachment.html