How to print the model date in a script?

[michielper]

I would like to have my script print the last modification date/time of the current EA model. I know how to do this with the DocumentGenerator but I am not using that in this particular script.

Preferably, I would like to be able to access the modification date/time of the running script itself, would that be possible?

[qwerty]

Probably the easiest way is to run a SQL over t_object and get the most recent modification date. Depends on the type of SQL you are using to obtain the first record only.

q.

[Geert Bellekens]

The scripts themselves can be found in t_script, but the don't store a modification date, so not really possible.

As for the last modified date on the model, there are modifiedDates in both t_object as t_diagram.

I guess if you take the most recent of the two you'll be close to the last modified date.
It's not 100% accurate as I can still change other thing (connectors, attributes, tests, etc...) without affecting any of these modification dates, but it is probably close enough.
In SQL server that query could be

Code: [Select]

select top (1) m.ModifiedDate
from
(select o.modifiedDate from t_object o
union
select d.ModifiedDate from t_diagram d) m
order by m.ModifiedDate desc

Geert