Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: jack89 on June 08, 2021, 12:00:13 am

Title: [EA 15.2] Query request to extract created date and updated date
Post by: jack89 on June 08, 2021, 12:00:13 am

Hi all,

I need to extract from my model the created date and updated date for the following cases:

1) Each element of the model
2) Each Diagram of the model
3) Each element under package "X"

Anyone is able to provide me these query?

Thank you in advance

Title: Re: [EA 15.2] Query request to extract created date and updated date
Post by: qwerty on June 08, 2021, 12:08:45 am

SELECT CreatedDate, ModifiedDate FROM t_object
SELECT CreatedDate, ModifiedDate FROM t_diagram
SELECT CreatedDate, ModifiedDate FROM t_object WHERE packageID = <theId>

q.

Title: Re: [EA 15.2] Query request to extract created date and updated date
Post by: jack89 on June 11, 2021, 10:05:32 pm

Thank you, is it possible to extract the number of modification for each diagram?

Title: Re: [EA 15.2] Query request to extract created date and updated date
Post by: qwerty on June 11, 2021, 10:29:20 pm

No, not really. You would need to make some sort of baseline comparison. And that's nor really funny. EA does have that functionality. But honestly, the effort to retrieve the actual change and especially their meaning is anything but a trivial task.

q.