2
« on: May 09, 2014, 05:03:14 pm »
I want to generate a Systems Resource Flow Matrix (DoDAF SV-6). The SV-6 is basically a table that is generated with a SQL query. This query can be found in the DoDAF Framework example, included in the UPDM MDG plugin.
The query works fine for connectors that have one information item attached via the Advance => Information Flows Realized menu.
If there are two or more items attached to the connector, then the query does not return any data for this connector.
The query should be fixed to handle this. I do not have the DB schema. Can anybody provide support?
SQL code:
=======
This search executes the following SQL query:
SELECT CONNECTOR.Name AS Connector_Name,
CONNECTOR.Stereotype AS Connector_Type,
FLOW.Stereotype AS Flow_Type,
CONVEYED.Stereotype AS Conveyed_Type,
CONVEYED.Name AS Conveyed_Name,
PRODUCER.Stereotype AS Producer_Type,
PRODUCER.Name AS Producer_Name,
CONSUMER.Stereotype AS Consumer_Type,
CONSUMER.Name AS Consumer_Name
FROM t_xref XCONVEYED, t_xref XABSTRACTION, t_object CONVEYED,
t_connector FLOW, t_object PRODUCER, t_object CONSUMER,
t_connector CONNECTOR, t_diagramlinks, t_diagram
WHERE XCONVEYED.Behavior='conveyed'
AND XCONVEYED.Description LIKE '#WC#' + CONVEYED.ea_guid + '#WC#'
AND XCONVEYED.Client=FLOW.ea_guid
AND FLOW.Start_Object_ID=PRODUCER.Object_ID
AND FLOW.End_Object_ID=CONSUMER.Object_ID
AND XCONVEYED.Client=XABSTRACTION.Description
AND XABSTRACTION.Client=CONNECTOR.ea_guid
AND CONNECTOR.Connector_ID=t_diagramlinks.ConnectorID
AND t_diagramlinks.DiagramID=t_diagram.Diagram_ID
AND t_diagram.StyleEx LIKE '#WC#MDGDgm=UPDM2_SV#WC#'
To execute the query, double-click the hyperlink.
Show Posts