topic Re: Detecting Document Update Type in Windchill Customization

Detecting Document Update Type

AdamElkins — Fri, 20 Jun 2025 14:01:39 GMT

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.

Re: Detecting Document Update Type

d_graham — Sat, 21 Jun 2025 20:29:59 GMT

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.

Re: Detecting Document Update Type

Fadel — Sat, 21 Jun 2025 21:05:25 GMT

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

Re: Detecting Document Update Type

AdamElkins — Wed, 09 Jul 2025 15:46:29 GMT

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.

Re: Detecting Document Update Type

AdamElkins — Wed, 09 Jul 2025 15:48:32 GMT

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!