[mapguide-users] Feature Joins - How?

[Andy Morsell]

It sounds like you have an outer join specified for your join rather than an
inner join.  In Studio 2009, you have the option of selecting an outer or
inner join.  If you're not using Studio 2009, I'm not sure what options you
have, but you can edit the XML and upload the datasource via the mapagent.
The XML element <RelateType> should be set to Inner. 

Andy Morsell, P.E.
Spatial Integrators, Inc.
www.SpatialGIS.com


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of
Crispin_at_1Spatial
Sent: Monday, August 25, 2008 5:56 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Feature Joins - How?


Hi,

Trying to understand feature joins so I tried some tests and failed
miserably... can anyone expand on the logic below:

 1) I created a new featuresource and layer (SDF data), turned the FeatId on
as the tooltip and previewed the data, noted down a FeatId that I could
readily identify (e.g. 123)

 2) I created an Access DB with a new table and a column (Numeric, Long)
called ID_NumLong and made it a primary key, then added one value to the
table as noted above (e.g. 123)

 3) I added an ODBC system DSN to the MDB and in MapGuide a new ODBC feature
source connection.

 4) I edited my original layer, linked the new ODBC featuresource as a join
and selected FeatId->ID_NumLong as an Inner join

 5) Previewed the layer expecting to see only the linked feature displayed
... but the complete dataset displayed as before.  Not happy.

-- 
View this message in context:
http://n2.nabble.com/Feature-Joins---How--tp781352p781352.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users