Detecting Document Update Type

[AdamElkins]

Version: Windchill 12.1

Use Case: I am migrating content from 1 system to another and am trying to make it as efficient as possible and avoid exporting documents when I don't need to.

Description:

I am identifying documents that have been updated by looking at updateStamp and modifyStamp. If a user checks out a document and checks it back in, is there any way to identify if the content of the document changed, or it was just a metadata change event? I am trying to avoid unnecessarily exporting content if it has not changed.

[d_graham]

The answer is a SQL statement that returns the doc where createstamp on the link that links the doc to the content item is the same as the createstamp of the content item.

If the dates are the same then this is the iteration with the original upload of the file. All other subsequent iterations that reference that same file will have dates that don’t match.

I’d suggest write an sql script and experimenting by making a doc with content and then checkout and edit that doc but keep the existing file.

Display the dates of all db entries in hour min sec.
This will make it very clear as to the order of when dB entries are created/modified.

[AdamElkins]

My solution needs to work with Windchill+ and likely needs to use the REST API's, so this is a good idea, but I don't think its an option for me.

[Fadel]

Take a look at https://www.ptc.com/en/support/article/CS308045 , the QML report will return the last modified time of the doc primary content , you need modify the report to compare doc and content modification dates 

[AdamElkins]

I don't think the QML report is what I need, but the idea of looking at the updateStamp or modifiedStamp of the primary content object associated with my windchill object is a good idea. I'll look into that. Thanks!