[mapguide][MG468][New] Enhanced Join Support

[Ronnie Louie]

You can view the artifact detail at the following URL:

    https://mapguide.osgeo.org/servlets/Scarab/id/MG468

Type
 Enhancement

Artifact ID
 MG468 (Enhanced Join Support)

Reported by
 Ronnie Louie
 ronnielouie (ronnie.louie at autodesk.com)

New artifact details:
---------------------------------------------------------

- Priority set to new value
  P2
- Artifact Status set to new value
  New
- Description set to new value
  Current join support is limited to left outer join type only. This means that the result consists of all feature records from the primary source, even if the attributes are null. An inner join is defined as a join that results in only the features that have a match in both joined feature sources.

A chained join is one in which the secondary source for a previously defined joined is used as a primary source for another join. This situation occurs when there is a need to join a secondary table to another secondary table, not just hang all secondary tables off the primary one.

It is possible that a secondary source within a join might have multiple records that match one primary record. This is a 1 : many case. Current functionality limits the joined records to only the first one, effectively enforcing a 1 : 1 case, such that the additional matching records are not available in the join result. By supporting the 1 : many case, all the joined secondary data is available for further analysis.

See MapGuide RFC 5 for more details at http://wiki.osgeo.org/index.php/MapGuide_RFC_5_-_Enhanced_Join_Support
- Justification set to new value
  See MapGuide RFC 5 - Enhanced Join Support at http://wiki.osgeo.org/index.php/MapGuide_RFC_5_-_Enhanced_Join_Support for more details.
- Artifact created
- Summary set to new value
  Enhanced Join Support

---------------------------------------------------------
This message was automatically generated by Project Tracker.