[mapguide-users] Feature Joins

[Chris Tallman]

I'm doing an Outer 1-Many Join.  It's the Many that seems to be broken.
Only the first match is joined.  I would guess this may have been one of
the issues in 1.2.
 
Right now 2.0 isn't really an option for us.  I have been testing, but
we're not ready to move over to it.  I have tried to make this same join
in 2.0 but the test machine either isn't big enough or the join really
consumes alot of resources.
 
Chris

________________________________

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Bruce
Dechant
Sent: Monday, March 10, 2008 11:42 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Feature Joins



Chris,

 

MGOS 1.2 did have some join issues and I believe you might be
encountering one of them. Are you doing an inner or outer join?

With MGOS 2.0 I have joined SDFs with Access many times in the following
cases:

 

Inner 1-1

Inner 1-Many

Outer 1-1

Outer 1-Many

 

The above worked for my use cases with MGOS 2.0. Would you be able to
try MGOS 2.0?

 

Thanks,

Bruce

 

 

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Chris
Tallman
Sent: Monday, March 10, 2008 7:28 AM
To: MapGuide Users Mail List
Subject: [mapguide-users] Feature Joins

 

Morning all.

 

Is anyone seeing issues with joins, using one-to-many?  I have an sdf
feature joined to a MSAccess file.  I'm only seeing the first join per
feature, the second, third and on are ignored.  

 

I'm on MGOS 1.2 IIS 6 .net install. 

 

I've created the same join in autocad and I don't have a problem.

 

More detail:  I have a sdf feature source that is buildings.  My
database has a list of majors.  Both have a Building ID.  One id per
building. Multiple majors per building.  I'm trying to create layers
based on the join that displays buildings based on majors.  If a
building has multiple majors it only shows up once and it seems to only
be the first match it comes across.  So I guess it's acting more like a
one-to-one join.

 

I hope this enough explanation someone will be able to help me out.  If
not let me know and I can try and explain more.

 

Chris Tallman

Director of GIS Operations

Innovation Mapping, LLC

260-356-9074

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080311/0af6d36b/attachment.html