In database, identify updates that move an object from one package to another?

[mjm]

Hello -

I am trying to figure out what column values are updated when an object is moved from one package to another. I can see that the t_object.package_id value is updated, and that the t_package.modifieddate value is updated. I am trying to write a query that identifies objects that have been moved in to a specific package hierarchy within a given date range while (hopefully) excluding objects that have had updates other than package location (for example, if the object name or stereotype was changed, but the object has not been moved, that element should be excluded). Is there any way to isolate these types of updates given the data available?

Thanks in advance!

[Helmut Ortmann]

Hello,

I think you have identified the columns that are updated.

The best description of the EA tables I know is Thomas Kilians eBook InsideEA.

It's possible that you get more information if you switch on the audit option of the EA-Repository. I'm not familiar with that option.

Regards,

Helmut

[qwerty]

When moving an object between packages then only t_package.package_id  (API: EAPackage.packageId) is changed.

q.

[mjm]

Thank you both for your input!

[Geert Bellekens]

To give you an answer to your question: No, with a simple query it is not possible to select only those element who have changed package in a given timeframe.
If you are interested in information like that you should look into the auditing feature.

Another option could be to make an add-in that reacts to the event of changing the packageID, and logs it somewhere.
The latter option would require the add-in to be installed an active on connected EA installations.

Geert