Finding where a InformationItem is conveyed

[Robert Sheridan]

I can run a report to ouput all the information items conveyed on connections on a diagram but I can not find a way to output all the connections a selected informationItem is used on (I have not delved into scripting or SQL).  Has anyone else tried to do this?

[qwerty]

Try a search (button left top) with "conveyed" for the last year. That will return some results.

q.

[Robert Sheridan]

Thanks for the pointer.

My users are new to EA so I was hoping for a 'right click' on an informationItem solution and was double checking that I had not missed something.  I will raise a feature request.

[qwerty]

Good luck with that :-) I remember times when feature requests were realized within a few months. Now we've reached more of a time range of decades

q.

[Helmut Ortmann]

With script and SQL-Search it's possible (not a perfect solution).

Write a SQL-Search with the GUID as <Search Term> and output the diagram, Source Element and Target Element. Then you can easily navigate to the diagram and with luck you see your item.

Write a browser script which calls the Search with the GUID.
Put the browser script into a browser script group.

Then you have your search at the context menue in the project browser.

To make it a bit easier to use you may write a Search Script (type  Model Search Group) to open the diagram of the selected connector and select the source and target of the connector.

I admit, if you haven't done it before it will take some time.

Helmut

[Robert Sheridan]

I will have a go at the script later.  In the meantime, below is some SQL I put together with help from the forum and Thomas' book to list all instances of an informationItem being conveyed on a connector including the diagram that it appears on.

select InfoItem.Name as InformationItem, t_connector.Name, t_connector.Top_Mid_Label, t_connector.Direction, Source.Name as SourceElement, Dest.Name as DestElement, t_diagram.Name as DiagramName, InfoItem.ea_guid as CLASSGUID, InfoItem.Object_Type AS CLASSTYPE
from t_connector, t_xref, t_object as InfoItem, t_object as Source, t_object as Dest, t_diagramlinks, t_diagram
where t_diagramlinks.DiagramID = t_diagram.Diagram_ID
and t_connector.Connector_ID = t_diagramlinks.ConnectorID
and t_connector.ea_guid = t_xref.Client
and t_connector.Start_Object_ID = Source.Object_ID
and t_connector.End_Object_ID = Dest.Object_ID
and t_xref.Description = InfoItem.ea_guid
and InfoItem.Object_Type = 'InformationItem';

********* SQL updated as per Helmut's suggestion below, but for jumping to project browser ******

[Helmut Ortmann]

If you start your SQL with:

Code: [Select]

select t_diagram.ea_guid AS CLASSGUID, t_diagram.diagram_type AS CLASSTYPE,..

you can jump from the search window to the diagram.

Helmut