How Items-conveyed are linked to Information-Flows?

[ngong]

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.

[Geert Bellekens]

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

Geert

[ngong]

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.

[Geert Bellekens]

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

[qwerty]

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.

[ngong]

@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>*'