Skip to main content
N
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

  • August 22, 2023
  • 1 reply
  • 1216 views

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

 

 

 

 

Best answer by avillanueva

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.

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald IAnswer
23-Emerald I
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.

    N
    NP_1057040712-AmethystAuthor
    12-Amethyst
    August 22, 2023

    Thanks for the Quick help.

    Terms & ConditionsCookie settingsAccessibility statement