Messages

1

Automation Interface, Add-Ins and Tools / Enterprise Architect and AI

« on: July 01, 2025, 03:03:18 pm »

Please let me know how to use AI to create models, does EA has this capability?

2

Automation Interface, Add-Ins and Tools / Re: Custom Documentation - SQL query

« on: June 13, 2025, 03:16:05 pm »

Thank you, I have learnt two things 1) that not to use numeric IDs and instead to use #ObjectID# to call any model element 2) define the table names like t_connector as link and use it as required.

My previous msg is
In Level1-  The code brings level 1 architecture (BDD) elements as Element1, Element 2, Element3... having aggregation relation.
In Level 2 - There is another BDD,s  available inside any one or two or more of the level 1 BDD elements (say Element1,Element2,Element3...) in aggregation relation.

In level the start object element becomes the end object if it contains any BDD in as child diagarm,How to bring those elements also.

SELECT source.Name AS ComponentName
FROM t_object AS source
LEFT JOIN t_connector AS link1
    ON link1.Start_Object_ID = source.Object_ID
    AND link1.Connector_Type = 'Aggregation'
LEFT JOIN t_object AS target
    ON link1.End_Object_ID = target.Object_ID
WHERE target.Object_ID = #OBJECTID#

Output:
Element1
Element2
Element3

3

Automation Interface, Add-Ins and Tools / Custom Documentation - SQL query

« on: June 11, 2025, 09:51:37 pm »

Hi team,

Below is the code used to bring the level 1 components, wanted to bring the level 2 components also which is connected as a child diagram to any one of the level1 component, Need support to modify this code.
select
t_object.Name as Name
FROM t_object
INNER JOIN t_connector ON t_object.Object_ID = t_connector.Start_Object_ID
WHERE t_connector.connector_Type = 'Aggregation'
AND t_connector.End_Object_ID = 1097