[mapguide-users] Feature Joins - How?

[Crispin_at_1Spatial]

Thanks Andy,

I know what you are saying (but sure it was an "Inner" join) - I authored in
Studio and verified in Maestro but will try again especially if someone can
run through the steps below independantly.  Meastro also has an
"Associative" join - do you know what that is?


Andy Morsell wrote:
> 
> 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
> 
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

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