Capturing Connector Message Data

[Gayle]

My model in EA 12.1 has a number of use cases with sequence diagrams.  Each connector in the sequence diagram has detailed message information.  The information I am interested in includes:  diagram where the message/connector is used, order / sequence of the messages, message name and parameters, condition (we use this to describe the trigger for the message), notes, sender and receiver.  Even though messages are reused across multiple diagrams, the condition and notes are unique to each instance.

Using a script, I have been able to collect the following:
- Diagram name
- Connector sequence number
- Connector name (Message with parameter)
- Connector supplier name (Sender)
- Connector client name (Receiver)
- Connector Notes

I have not been able to find a field that contains the connector/mesage "condition".  Any suggestions?

Gayle

[qwerty]

t_connector.Btm_Mid_Label (p. 80 of my Inside book).

q.

[Gayle]

I'm new to scripting in EA and don't know how to translate your response to use in the script.  The script is written in VB.

Gayle

[qwerty]

Issue a

Code: [Select]

Respository.SQLQuery("SELECT Btm_Mid_Label FROM t_connector WHERE connector_id = <theId>")where <theId> is the appropriate connector id.

q.

[Gayle]

I ended up with a slightly different statement:

messageConnectorTemp = Repository.SQLQuery ("SELECT Btm_Mid_Label FROM t_connector WHERE connector_id = " & temp.ConnectorID)

The main issue I had with the output is that extra data comes both before and after the text string that I'm interested in.  I used "Replace" statements to remove the data and I now have useable text.

Thank you, Gayle

[qwerty]

If you're going to work on larger result sets you should use a DOM parser for the XML output that comes out of the SQLQuery. But for a single returned row a simple string manipulation is sufficient.

q.

[Gayle]

I decided to try your suggestion and it resolved a problem that I encountered with the "Replace" function.  For some reason, I was getting an extra carriage return between the text "Trigger:  " and the data obtained from the SQL query.  This extra carriage return is now gone using the XML DOM tools.

Thank you for the suggestion.

Gayle