UPDM / DoDAF SV-6

[bergtwvd]

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.

[natvig]

The problem with this query is that it only checks for the first occurrence of a ea_guid in ABSTRACTION.Description. If there are more than one conveyed item these are all put in the same field (Description). You need to modify the search as follows:

...
AND FLOW.End_Object_ID=CONSUMER.Object_ID
AND XCONVEYED.Client in (
left(XABSTRACTION.Description,38),
mid(XABSTRACTION.Description,40,38),
mid(XABSTRACTION.Description,79,38),
mid(XABSTRACTION.Description,118,38))
AND XABSTRACTION.Client=CONNECTOR.ea_guid
...

The above example will be able to find at most 4 conveyed items on each connector.

/Hans