Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Luigi2021 on July 13, 2022, 05:33:07 pm

Title: Where are milestones from resource allocation stored in the database
Post by: Luigi2021 on July 13, 2022, 05:33:07 pm

Hi,

Where in the database is the value stored that is set in the milestones property in the assign resource editor?

Thanks in advance!

Kind regards,

Luigi

Title: Re: Where are milestones from resource allocation stored in the database
Post by: qwerty on July 13, 2022, 05:38:30 pm

Actually I have no idea, but I'd first search in t_xref and then t_document. Simple watch for db changes when adding a milestone. I'd do that but I'm really busy with other things like re-building my terrace.

q.

Title: Re: Where are milestones from resource allocation stored in the database
Post by: Luigi2021 on July 13, 2022, 08:06:12 pm

I've found it. It's in the t_xref table, the type must be t_objectresource and the "Supplier" contains the milestone's guid.

Thanks for your help and good luck with your terrace.