{"id":2687,"date":"2018-05-16T16:28:03","date_gmt":"2018-05-16T14:28:03","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=2687"},"modified":"2018-06-07T08:31:54","modified_gmt":"2018-06-07T06:31:54","slug":"sparx-systems-enterprise-architect-get-composite-diagram-by-sql","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=2687","title":{"rendered":"Sparx Systems Enterprise Architect: Get Composite Diagram by SQL"},"content":{"rendered":"

Problem<\/h1>\n

The menu point „Set Composite Diagram“ allows to create a clickable link to another diagram from objects. Unfortunetly to get the references in SQL (with start and end GUID) is a little bit tricky…<\/p>\n

\"\"<\/a><\/p>\n

Approach<\/h1>\n

Open the .eap (MDB Plus<\/a>) file or der SQL Server structure (MS SQL Server Studio Express) in a tool that allows you to test SQL Statements<\/p>\n

Solution<\/h1>\n

Composite Diagrams of Activities<\/h2>\n

i.e. for the .eap-File (Access):
\nTo get the activities Composite diagrams, you need to join the t_object.PData1 Columne with the t_diagram.Diagram_ID Column. This can be done in the following way:<\/p>\n

\r\nSELECT compobjects.ea_guid As src_guid,\r\n       compobjects.name As src_name,\r\n       b.ea_guid As dest_guid,\r\n       b.name As dest_name \r\nFROM \r\n(\r\n      SELECT ea_guid, \r\n             Name, \r\n             Object_Type, \r\n             Stereotype, \r\n             PData1 \r\n      FROM t_object \r\n      WHERE NType=8 AND PData1 IS NOT null AND isnumeric(PData1)) compobjects\r\nINNER JOIN t_diagram b ON b.Diagram_ID=CInt(compobjects.PData1)\r\n<\/pre>\n
Composite Diagrams of Classes<\/h2>\n
\r\nSELECT Client As src_guid, \r\n       obj.name As src_name, \r\n       Supplier As dest_guid, \r\n       obj2.name As dest_name   \r\nFROM ( t_xref xr\r\nLEFT JOIN t_object obj ON xr.Client=obj.ea_guid)\r\nLEFT JOIN t_diagram obj2 ON xr.Supplier=obj2.ea_guid \r\nWHERE Supplier<>'<none>'\r\n<\/pre>\n
All Composites by source guid<\/h2>\n
\r\nSELECT src_guid,\r\n       src_name,\r\n       dest_guid,\r\n       dest_name\r\nFROM       \r\n(\r\n\tSELECT compobjects.ea_guid As src_guid,\r\n\t\t   compobjects.name As src_name,\r\n\t\t   b.ea_guid As dest_guid,\r\n\t\t   b.name As dest_name \r\n\tFROM\r\n\t(\r\n\t\t  SELECT ea_guid, \r\n\t\t\t\t Name, \r\n\t\t\t\t Object_Type, \r\n\t\t\t\t Stereotype, \r\n\t\t\t\t PData1 \r\n\t\t  FROM t_object \r\n\t\t  WHERE NType=8 AND PData1 IS NOT null AND isnumeric(PData1)) compobjects\r\n\tINNER JOIN t_diagram b ON b.Diagram_ID=CInt(compobjects.PData1)\r\n\tUNION ALL \r\n\tSELECT Client As src_guid, \r\n\t\t   obj.name As src_name, \r\n\t\t   Supplier As dest_guid, \r\n\t\t   obj2.name As dest_name   \r\n\tFROM ( t_xref xr\r\n\tLEFT JOIN t_object obj ON xr.Client=obj.ea_guid)\r\n\tLEFT JOIN t_diagram obj2 ON xr.Supplier=obj2.ea_guid \r\n\tWHERE Supplier<>'<none>'\r\n)\r\nWHERE src_guid='Put your GUID here'\r\n<\/pre>\n