C# how to get diagram name of element - Enterprise Architect

Question

I need to get diagram`s name of specific elements. Is it possible ?

I added elements note with specific stereotypu using profile to EA project. Then i want create a plugin where i find this notes and diagram names where they are located. (i want export notes and diagram names to excel)....PS: Sorry for my bad english

Answer 1

Issue a SQL like

Repository.SQLQuery("SELECT t_diagram.name FROM t_diagramobjects AS dobj INNER JOIN t_diagram  ON dobj.diagram_id = t_diagram.diagram_id WHERE  t_diagramobjects.Object_ID = <elementID>"

Just replace <elementID> with the element's elementID. You could alternatively retrieve the diagram GUID (t_diagram.ea_guid') and get the diagram details viaRepostory.GetDiagramByGUID`.