{"id":2710,"date":"2018-06-07T08:29:13","date_gmt":"2018-06-07T06:29:13","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=2710"},"modified":"2018-06-07T08:35:08","modified_gmt":"2018-06-07T06:35:08","slug":"sparx-systems-enterprise-architect-get-images-of-diagram-by-diagram-name-sql","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=2710","title":{"rendered":"Sparx Systems Enterprise Architect: Get Images of Diagram By Diagram Name SQL"},"content":{"rendered":"<h1>Problem<\/h1>\n<p>The Images of a specific diagram in the data structure of the Sparx Systems Enterprise Architect should be read by diagram name.<\/p>\n<h1>Approach<\/h1>\n<p>Usage of MDB Plus and Data Mining<\/p>\n<h1>Solution<\/h1>\n<p>This is SQL for the Access \/ .eap-File &#8211; it should be rewritten for other SQL Servers (i.e. the brackets can be removed and Functions like InStr\/Mid shall be replaced)<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT\tdia.Name As Diagram,\r\n\t\tIIF(Trim(objstart.&#x5B;Name]) = 'Text', 'Text', objstart.stereotype) As stereotype, \r\n\t\tdiaobj.RectLeft As x,\r\n\t\tdiaobj.RectTop As y,\r\n\t\tdiaobj.RectRight-diaobj.RectLeft As Width,\r\n\t\tAbs(diaobj.RectBottom-diaobj.RectTop) As Height,\r\n\t\tobjstart.Object_ID,\r\n\t\tIIF(Trim(objstart.&#x5B;Name]) = 'Text', 'Text-'&amp; objstart.Object_ID ,objstart.Alias) As &#x5B;key],\r\n\t\tIIF(objstart.&#x5B;Name] = 'Text', objstart.Note, objstart.&#x5B;Name]) As phaseName,\r\n\t\tobjstart.&#x5B;ea_guid] As &#x5B;guid],\r\n\t\tdiaobj.ObjectStyle,\r\n\t\tIIF(\r\n                    InStr(diaobj.ObjectStyle, &quot;ImageID&quot;)&gt;0, \r\n                    Mid(diaobj.ObjectStyle, InStr(diaobj.ObjectStyle, &quot;ImageID&quot;)+8 , Len(diaobj.ObjectStyle)- (InStr( diaobj.ObjectStyle, &quot;ImageID&quot;)+8) ),\r\n                    ''\r\n        ) As ImageId     \r\nFROM\r\n((\r\n\t\t&#x5B;t_diagram] dia LEFT JOIN (Select Diagram_ID, Object_ID, RectLeft, RectTop, RectRight, RectBottom, ObjectStyle from &#x5B;t_diagramobjects]) diaobj ON dia.&#x5B;Diagram_ID]=diaobj.&#x5B;Diagram_ID])\r\nLEFT JOIN &#x5B;t_object] objstart ON objstart.&#x5B;Object_ID]=diaobj.&#x5B;Object_ID])\r\nWHERE objstart.Object_Type IN ('Text','Boundary') AND IIF(InStr(diaobj.ObjectStyle, &quot;ImageID&quot;)&gt;0, \r\n                                                                Mid(diaobj.ObjectStyle, InStr(diaobj.ObjectStyle, &quot;ImageID&quot;)+8 , \r\n                                                                Len(diaobj.ObjectStyle)- (InStr( diaobj.ObjectStyle, &quot;ImageID&quot;)+8) ),\r\n                                                                '') &lt;&gt; ''\r\nAND dia.Name='0' \r\nORDER BY 12 DESC,1,2,3,4,5,6,7,8,9       \r\n<\/pre>\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fwww.capri-soft.de%2Fblog%2F%3Fp%3D2710&amp;layout=standard&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px;margin-top:5px;\"><\/iframe>","protected":false},"excerpt":{"rendered":"<p>Problem The Images of a specific diagram in the data structure of the Sparx Systems Enterprise Architect should be read by diagram name. Approach Usage of MDB Plus and Data Mining Solution This is SQL for the Access \/ .eap-File &#8211; it should be rewritten for other SQL Servers (i.e. the brackets can be removed &hellip; <a href=\"https:\/\/www.capri-soft.de\/blog\/?p=2710\" class=\"more-link\"><span class=\"screen-reader-text\">Sparx Systems Enterprise Architect: Get Images of Diagram By Diagram Name SQL<\/span> weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[16,10,11,28,43],"tags":[],"class_list":["post-2710","post","type-post","status-publish","format-standard","hentry","category-access","category-datenbanken","category-ms-sql-server","category-sparx-systems-enterprise-architect","category-sql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4yGeN-HI","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2710"}],"version-history":[{"count":2,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2710\/revisions"}],"predecessor-version":[{"id":2737,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2710\/revisions\/2737"}],"wp:attachment":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}