Find MDG Diagrams via SQL

[[email protected]]

How can I retrieve diagrams of a certain MDG 'type' in SQL.

I know for Elements I have to create a join between t_object and t_xref where t_xref stores the MDG Stereotype I'm looking for.

How do I do the same for diagrams (assuming the FQN of my 'type' is MDG::DIAGRAM)?

Thanks

[qwerty]

You need to look into t_diagram.styleex. It will contain something like MDGDgm=Archimate2::Business;

q.

[[email protected]]

Found it, thanks!

Follow-up question 1: Where will I find the short form of the 'type' as used in the diagram frame "Bdd", "Req" and the like?

[qwerty]

You need to derive it from Diagram_Type (via a table).

q.

[Eve]

Follow-up question 1: Where will I find the short form of the 'type' as used in the diagram frame "Bdd", "Req" and the like?

For any MDG technology it's specified by the technology itself. The string isn't accessible via the API or stored in the database.

[[email protected]]

Errrrr... OK some confusion here.

So I can understand how the digram 'kind' could be hard coded for UML & SysML, but for custom diagrams specified by an MDG, how does EA render the diagram frame if it doesn't store this information in the DB?

Does it just read the MDG data from the XML at startup and hold it in memeory?

If this is this case then presumably it has to re-generate the diagram frame (or at least the heading) every time one is required?

[qwerty]

Does it just read the MDG data from the XML at startup and hold it in memeory?

Yes.

q.