Backtracking Information Items

[Jalakas]

Adding information items to an information flow gives me a tool for coupling flows and information items. But what I know I can only view this relationship by picking a certain connector and select "Information Items Conveyed".

I would like to do it the other way around. Be able to list what Information Flows are related to a certain Information Item. That is, starting from the Information Item and list "Information Flows Conveyed". Anyone who knows if this is possible?

[OpenIT Solutions]

Hi,

The SQL below might help:

select * from t_connector, t_xref, t_object where t_xref.Client = t_connector.ea_guid and t_xref.description = t_object.ea_guid

Run this in a search (or add to a search that you can then us when generating rtf docs) and click on an output row and the information item properties will be shown in ea.

Regards,

Jon.

[denty]

How could I use the results of the query to find out what diagrams the flow is shown in?

[Geert Bellekens]

see http://geertbellekens.wordpress.com/2011/01/14/harvesting-the-power-of-eas-sql-searches/


Geert

[Jalakas]

Interesting features I haven't previously explored. Originally though my intent was to find simple way to do it via the GUI.
/Robert

[OpenIT Solutions]

Great artical Geert.

@denty, try something like this (works on access, issue with type conversion on sql server) :

select  t_diagram.Diagram_ID AS CLASSGUID, t_diagram.Diagram_Type AS CLASSTYPE, t_diagram.Name, t_connector.Connector_Type, t_object.Name
from t_connector, t_xref, t_object, t_diagramobjects o1, t_diagramobjects o2, t_diagram
where t_xref.Client = t_connector.ea_guid
and t_xref.description = t_object.ea_guid
and (t_connector.Start_Object_ID = o1.object_id and t_connector.End_Object_ID = o2.object_id)
and t_diagram.Diagram_ID = o1.diagram_id

You can create a new "search builder" query with this, then use find in project browser on the search results to navigate to the diagram...

Regards,

Jon.