SQL-search definition for MODAF OV-3

[Lars]

Hello everyone!

I'm using one of the pre-defined search questions that comes with UPDM 2.0 in order to generate the MODAF OV-3 (Operational Information Exchange) view.

The SQL-question is formulated accordingly and for a start it works out well:

Code: [Select]

SELECT '«'+t_connector.Connector_Type+'» ' As Flödestyp, '«'+Conv.Stereotype+'» '+Conv.Name AS Informationsobjekt, '«'+Prod.Stereotype+'» '+Prod.Name AS Avsändare, '«'+Cons.Stereotype+'» '+Cons.Name AS Mottagare FROM t_connector, t_xref, t_object AS Conv, t_object AS Prod, t_object AS Cons WHERE t_connector.Connector_Type='InformationFlow' AND t_xref.Client=t_connector.ea_guid AND t_xref.Behavior='conveyed' AND t_xref.Description=Conv.ea_guid AND t_connector.Start_Object_ID=Prod.Object_ID AND t_connector.End_Object_ID=Cons.Object_ID ORDER BY Prod.Name, Cons.Name

My concern is how to get hold of the attributes (and their values) that are defined for the elements that are conveyed on the above selected connectors (InformationFlow), any ideas?

Lars

[qwerty]

t_attribute holds the object_id  of the element possessing it.

q.