Skip to main content
A
AdamElkins12-Amethyst
12-Amethyst
June 20, 2025
Question

Detecting Document Update Type

  • June 20, 2025
  • 2 replies
  • 684 views

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.

2 replies

D
18-Opal
d_graham18-Opal
18-Opal
June 20, 2025

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.

 

    A
    AdamElkins12-AmethystAuthor
    12-Amethyst
    July 9, 2025

    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
    Fadel23-Emerald I
    23-Emerald I
    June 21, 2025

    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 

    Buiꓘa
      A
      AdamElkins12-AmethystAuthor
      12-Amethyst
      July 9, 2025

      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!

      Terms & ConditionsCookie settingsAccessibility statement