Skip to main content
NP_1057040712-Amethyst
12-Amethyst
August 22, 2023
Solved

Windchill DB EPM reference type table column value and its UI displayed value is not matching

For EPMDocument  CAD Part references section (Related Objects Tab), other cad assembly objects are listed as reference type= "Relation Reference" whereas when we query for this record in database table, the same value is stored as just "REFERENCE". would like to know how and where this mapping is done.

Thanks in advance

 

 

 

 

avillanueva
avillanuevaAnswer
23-Emerald II
August 22, 2023

https://support.ptc.com/help//wnc/r12.0.2.0/en/index.html?_gl=1*1sko5q7*_ga*MTUwMTY4Mjg2LjE2OTA1NDIyMzI.*_ga_1QBT6P6HR1*MTY5MjcwNTczNy43My4xLjE2OTI3MDczOTQuNDAuMC4w*_ga_CBN5QVB9VJ*MTY5MjcwNTc0OC41My4xLjE2OTI3MDczOTQuMC4wLjA.#page/Windchill_Help_Center/ProEWCIntegCustInternalRelDisplayConfig.html

The column you are seeing is a code for DEPTYPE on the EPMREFERENCELINK table. The help link gives you a mapping. I was looking for a resource bundle but could not find one.

View in thread

2 replies

avillanueva
avillanueva23-Emerald IIAnswer
23-Emerald II
August 22, 2023

https://support.ptc.com/help//wnc/r12.0.2.0/en/index.html?_gl=1*1sko5q7*_ga*MTUwMTY4Mjg2LjE2OTA1NDIyMzI.*_ga_1QBT6P6HR1*MTY5MjcwNTczNy43My4xLjE2OTI3MDczOTQuNDAuMC4w*_ga_CBN5QVB9VJ*MTY5MjcwNTc0OC41My4xLjE2OTI3MDczOTQuMC4wLjA.#page/Windchill_Help_Center/ProEWCIntegCustInternalRelDisplayConfig.html

The column you are seeing is a code for DEPTYPE on the EPMREFERENCELINK table. The help link gives you a mapping. I was looking for a resource bundle but could not find one.

Translate
    NP_1057040712-AmethystAuthor
    12-Amethyst
    August 22, 2023

    Thanks for the Quick help.

    Translate
    Terms & ConditionsAccessibility statement