exporting Find in diagrams, element usage window

[PHS]

Is there a possibility to export results of "find in diagrams.." function? It presents list of diagrams in Element Usage window, and I need to copy&paste the results.

Regards,
Piotr

[qwerty]

Not directly. You can likely create a SQL to find usage in diagrams (at least with an add-in search). Those search results can be copy/pasted. I think the easiest way is to write a script that takes the currently selected element and puts the results on the pasteboard directly.

q.

[PHS]

This is the idea, I thought about too. Does anyone have such script ready, and is able to share it?

[qwerty]

Basically you need to use a query like

Code: [Select]

Repository.SQLQuery("SELECT Diagram_ID  FROM  t_diagramobjects WHERE Object_ID = <id>")where <id> is the element id of your element. Now you just need to find the info for the ids of the returned diagrams.

q.

[PHS]

Simple query to list sequence diagrams with particular component

Code: [Select]

select t_diagramobjects.Diagram_ID AS CLASSGUID, t_diagram.Diagram_Type AS CLASSTYPE, t_diagram.Name FROM t_object
LEFT JOIN t_diagramobjects
ON t_object.Object_ID=t_diagramobjects.Object_ID
LEFT JOIN t_diagram
ON t_diagramobjects.Diagram_ID=t_diagram.Diagram_ID
WHERE t_object.Object_Type = "Component" AND t_object.Name = "Component Name" AND t_diagram.Diagram_Type="Sequence"
ORDER BY t_diagram.Name;

Is it possible to make result list clickable ?

[qwerty]

In that form it should be :-/

q.

[KP]

select t_diagramobjects.Diagram_ID AS CLASSGUID, ...

t_diagramobjects.Diagram_ID doesn't hold a GUID. You probably need t_object.ea_guid or t_diagram.ea_guid instead.

[PHS]

Changing t_diagramobjects.Diagram_ID to t_diagram.ea_guid solved the problem. Thanks !