A SQL statement is needed, that returns a list of all link relations with start and end object name. Additionally a tagged value (here it is called ‚Object identifier‘) should be appended<\/p>\n
Usage of MDB Plus<\/p>\n
Note: If you do not need tagged values, you can customize the following Access \/ .eap-File Statement in the way that you reduce it by leaving out the last 2 LEFT JOINs (and don’t forget to remove the Columns from the Select clause).<\/p>\n
\r\nSELECT objstart.[Object_ID] As EAIDSource,\r\n objstart.[Name] AS EANameSource,\r\n objpropstart.[Value] AS DoorsSoruceObjectID,\r\n tconn.[Connector_ID] AS EAConnectorID,\r\n tconn.[Direction] AS EADirection,\r\n tconn.[Connector_Type] AS EAConnectorType,\r\n tconn.[Stereotype] AS EAStereoType,\r\n objend.[Object_ID] AS EAIDTarget,\r\n objend.[Name] AS EANameTarget,\r\n objpropende.[Value] AS DoorsTargetObjectID\r\nFROM \r\n((( \r\n[t_connector] tconn LEFT JOIN [t_object] objstart ON tconn.[Start_Object_ID]=objstart.[Object_ID])\r\n LEFT JOIN [t_object] objend ON tconn.[End_Object_ID]=objend.[Object_ID]) \r\n LEFT JOIN (SELECT [Object_ID], [Property], [Value] FROM [t_objectproperties] WHERE [Property]="Object identifier" ) objpropstart ON tconn.[Start_Object_ID]=objpropstart.[Object_ID] )\r\n LEFT JOIN (SELECT [Object_ID], [Property], [Value] FROM [t_objectproperties] WHERE [Property]="Object identifier" ) objpropende ON tconn.[End_Object_ID]=objpropende.[Object_ID]\r\n<\/pre>\n