Find information flows, which convey an item

[gfranz]

Hello,

our MDG uses information flows and items extensively. My current understanding is, that it is not possible to find all information flows, which convey a given information item, is it?

I think I saw a script as a workaround in this forum. But my forum search for "information flow" shows 0 results. Is there a script for it? It should at least point out the diagram and the source and target element.

Thanks!

[Geert Bellekens]

a quick search for "conveyed" revealed:
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1346661183/2#2
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1344953764/2#2

I think both answer your question.

Geert

[Helmut Ortmann]

Hello,

I see two ways:
1. Addin/Scrip
currentConnector.ConveyedItems (Collection)

2. SQL

Code: [Select]

SELECT DISTINCT o.ea_guid as CLASSGUID, o.Object_Type as CLASSTYPE,
 o.name As Item, o.Object_Type As ItemType, o.stereotype As ItemStereotype, 'Connector' As ConnectorType, c.Name, c.Stereotype
 
FROM t_object o,
          t_xref xCon, t_xref xFlow,
          t_connector c,
    t_connector flow
where
  c.connector_ID = <Search Term>
and   c.ea_guid = xCon.Client
and   xCon.Behavior = 'abstraction'
and flow.ea_guid in
(
#DB=SQLSVR#             substring(xCon.description,0,39),
                                      substring(xCon.description,39,39),
                                      substring(xCon.description,78,39),
                                      substring(xCon.description,117,39),
                                      substring(xCon.description,156,39),
                                      substring(xCon.description,195,39),
                                      substring(xCon.description,234,39),
                                      substring(xCon.description,273,39),
                                      substring(xCon.description,312,39),  
                                      substring(xCon.description,351,39)
#DB=SQLSVR#  
#DB=ORACLE#
           SubStr(Cast(xCon.description As Varchar(39)),0,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),40,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),79,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),118,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),157,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),196,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),235,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),274,38),
                                      SubStr(Cast(xCon.description As Varchar(39)),313,38),  
                                      SubStr(Cast(xCon.description As Varchar(39)),352,38)

#DB=ORACLE#
#DB=Other#                left(xCon.description,38),
                                      mid(xCon.description,40,38),
                                      mid(xCon.description,79,38),
                                      mid(xCon.description,118,38),
                                      mid(xCon.description,157,38),
                                      mid(xCon.description,196,38),
                                      mid(xCon.description,235,38),
                                      mid(xCon.description,274,38),
                                      mid(xCon.description,313,38),  
                                      mid(xCon.description,352,38)
#DB=Other#  
  )
AND         flow.ea_guid = xFlow.client
AND         o.ea_guid in  
(
#DB=SQLSVR#             substring(xFlow.description,0,39),
                                      substring(xFlow.description,39,39),
                                      substring(xFlow.description,78,39),
                                      substring(xFlow.description,117,39),
                                      substring(xFlow.description,156,39),
                                      substring(xFlow.description,195,39),
                                      substring(xFlow.description,234,39),
                                      substring(xFlow.description,273,39),
                                      substring(xFlow.description,312,39),  
                                      substring(xFlow.description,351,39)
#DB=SQLSVR#    
#DB=ORACLE#
           SubStr(Cast(xFlow.description As Varchar(39)),0,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),40,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),79,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),118,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),157,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),196,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),235,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),274,38),
                                      SubStr(Cast(xFlow.description As Varchar(39)),313,38),  

If you drop me a message I send you the whole SQL.

Helmut