Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ngong on March 24, 2021, 10:51:33 pm

Title: How Items-conveyed are linked to Information-Flows?
Post by: ngong on March 24, 2021, 10:51:33 pm

I am about to do an SQL query to find the start and end object, connected by information flows for a certain data type.

Using the EASchema_1558, I can find information flows in t_connector. I can find data types in t_object, but I need a hint (or the documentation where it is explained) how they are linked.

Title: Re: How Items-conveyed are linked to Information-Flows?
Post by: Geert Bellekens on March 24, 2021, 10:58:54 pm

See https://www.sparxsystems.com/forums/smf/index.php/topic,44315.msg261422.html#msg261422 (https://www.sparxsystems.com/forums/smf/index.php/topic,44315.msg261422.html#msg261422)

Geert

Title: Re: How Items-conveyed are linked to Information-Flows?
Post by: ngong on March 25, 2021, 06:08:38 pm

Super, thank you Geert.

In my case we ruled that there shall be only one item per information-flow. Hence, I could reduce the complexity to

Code: [Select]

select dg.Name as diagram, od.Name as item, os.Name as start, oe.Name as end
from ((((((t_connector c
left join t_diagramlinks dl on dl.ConnectorID = c.Connector_ID )
left join t_diagram dg on dg.Diagram_ID = dl.DiagramID)
left join t_object oe on oe.Object_ID = c.End_Object_ID )
left join t_object os on os.Object_ID = c.Start_Object_ID )
inner join t_xref x on x.Client = c.ea_guid )
left join t_object od on (od.ea_guid in (left(x.Description,38))) )
where c.Connector_Type = 'InformationFlow' and x.Name = 'MOFProps' and od.Name like '*<Search Term>*'
Next question: Do you know a way to open the diagram shown on a result line by clicking or ctrl-u or the like? The CLASSGUID and CLASSTYPE magic works for objects, but not for connections.

Title: Re: How Items-conveyed are linked to Information-Flows?
Post by: Geert Bellekens on March 25, 2021, 06:28:18 pm

Quote from: ngong on March 25, 2021, 06:08:38 pm

Next question: Do you know a way to open the diagram shown on a result line by clicking or ctrl-u or the like? The CLASSGUID and CLASSTYPE magic works for objects, but not for connections.

It works for diagrams

Geert

Title: Re: How Items-conveyed are linked to Information-Flows?
Post by: qwerty on March 25, 2021, 08:46:20 pm

Connection properties can open in a docked properties window unless from the context menu of a connector. The search window can not perform that. EAUI.

q.

Title: Re: How Items-conveyed are linked to Information-Flows?
Post by: ngong on April 09, 2021, 01:44:53 pm

@Geert: yes, works fine: I can now open the diagram hosting the information flow, directly from the search result

Code: [Select]

select distinct dg.ea_guid as CLASSGUID, 'Diagram' as CLASSTYPE, dg.Name as diagram, dg.Diagram_Type as type, od.Name as item, os.Name as start, oe.Name as end
from ((((((t_connector c
left join t_diagramlinks dl on dl.ConnectorID = c.Connector_ID )
left join t_diagram dg on dg.Diagram_ID = dl.DiagramID)
left join t_object oe on oe.Object_ID = c.End_Object_ID )
left join t_object os on os.Object_ID = c.Start_Object_ID )
inner join t_xref x on x.Client = c.ea_guid )
left join t_object od on (od.ea_guid in (left(x.Description,38))) )
where c.Connector_Type = 'InformationFlow' and x.Name = 'MOFProps' and od.Name like '*<Search Term>*'