Skip to main content
P
ptc-39599914-Participant
4-Participant
February 10, 2022
Solved

Is there a way to query the history of the folder rename?

  • February 10, 2022
  • 2 replies
  • 1710 views

I am using Windchill PDMLink Release 11.0 and Datecode with CPS M030-CPS11

有辦法查詢到資料夾 rename 的歷程嗎?
有辦法查詢到資料夾 rename 的歷程嗎?
有辦法查詢到資料夾 rename 的歷程嗎?
有辦法查詢到資料夾 rename 的歷程嗎?

 

 

Is there a way to query the history of the folder rename?
Is there a way to query the history of the folder rename?
Is there a way to query the history of the folder rename?
Is there a way to query the history of the folder rename?

 

Translated by Iuliana Nuta with google translate, 10-feb-2021

Best answer by HelesicPetr

Hello @ptc-3959991 

Yes there is a way how to do that.

 

It is possible to select the change name history directly in a database for subfolders. 

mssql

select * from WindchillDB.IdentityChangeHistory where classnamekeyA3='wt.folder.SubFolder'

 

a idA3A3 is a internal identification of a folder.

hope this can help

 

Best Regards

 

PetrH

 

 

 

2 replies

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
February 21, 2022

Hello @ptc-3959991 

Yes there is a way how to do that.

 

It is possible to select the change name history directly in a database for subfolders. 

mssql

select * from WindchillDB.IdentityChangeHistory where classnamekeyA3='wt.folder.SubFolder'

 

a idA3A3 is a internal identification of a folder.

hope this can help

 

Best Regards

 

PetrH

 

 

 

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    March 8, 2022

    You can also use a query builder report like the one attached.

     

    Rename file extension from XML to QML

    Marco
      Terms & ConditionsCookie settingsAccessibility statement