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:[EMAIL PROTECTED] 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.
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
