Linking messages and operations using SQL

[Polymorph]

Can anyone suggest an SQL query that would be able to link a message on a sequence diagram to the actual operation on the block which classifies the lifeline.

The connector that represents the message the diagram has the same name as the operation, but... It also has parenthesis after the name. This means that trying to do an SQL JOIN statement doesn't work, since the name of the actual operation excludes the parentheses.

I'm no SQL guru so there might be a clever way to construct the query... Or perhaps there is another table with the info...?

[qwerty]

I'm also no SQL guru, but those things are usually quite DB dependent. So you should state which RDBMS you are targeting. E.g. the SUBSTRING function in Mickeysoft Access (aka EAP) is named MID.

q.

P.S.

Code: [Select]

SELECT mid(name,1, instr(1,name,'(',0)-1) from t_connector will strip the name before the parenthesis.

[KP]

The message will have a tagged value "operation_guid" which contains the GUID of the operation. The tagged value will be in the table t_connectortag, the message in t_connector and the operation in t_operation.

[Polymorph]

Excellent - that worked a treat!