Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Knut Paulsen on November 15, 2016, 11:54:44 pm

Title: Where are model and user default diagrams stored
Post by: Knut Paulsen on November 15, 2016, 11:54:44 pm

I had a discussion with Geert about this some time ago, but can't find it now :-)

Anyway, if you are interested the GUID of the Model Default Diagram is stored in the database table 'usys_system' under property name 'Default Diagram', and the GUID of the User Default Diagram is stored in the database table 't_xref' with Name 'Default Diagram', Type 'User Setting', Client is the GUID of the user (from table 't_secusers') and Supplier is the GUID of the default diagram.

Cheers
Knut

Title: Re: Where are model and user default diagrams stored
Post by: Uffe on November 16, 2016, 12:17:24 am

For completeness, if you create an EA shortcut from the File menu, you can specify one or more diagrams to be opened when that shortcut is used.

A shortcut can also do a few other things, so if someone stumbles onto this post wondering about weird things going on when opening a project, the shortcut file is worth a look.

/Uffe

Title: Re: Where are model and user default diagrams stored
Post by: Marc Vanstraelen on March 31, 2017, 01:00:23 am

This has helped me out today. So just for the fun of it, a little query I created based on this info to retrieve the list of User Default diagrams in the project:

Code: [Select]

select d.ea_guid as CLASSGUID, 'Diagram' as CLASSTYPE, d.Name as [Default_Diagram_Name], d.Author as [Diagram_Author], u.Surname, u.FirstName, u.UserLogin
from t_xref x, t_secuser u, t_diagram d
where x.Name = 'Default Diagram'
and u.UserID = x.Client
and d.ea_guid = x.Supplier
order by u.Surname