Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
We notice the infrastructure changes in the database schema starting Windchill 10.2 and it would be helpful if someone could suggest the new tables and joins so we get our query right.
Here is a working query from Windchill 9.1 system (PDMLink, PartsLink, SUMA and Oracle DB)
SELECT
M1.WTPARTNUMBER,
D1.VERSIONIDA2VERSIONINFO,
D1.ITERATIONIDA2ITERATIONINFO,
CN.NAME
FROM
REFERENCEDEFINITION R,
REFERENCEVALUE RV,
MANUFACTURERPARTMASTER M1,
MANUFACTURERPART D1,
CLASSIFICATIONNODE CN
WHERE
R.DISPLAYNAME = 'Part' AND
R.IDA2A2 = RV.IDA3A5 AND
RV.CLASSNAMEKEYA4 = 'com.ptc.windchill.suma.part.ManufacturerPart' AND
RV.IDA3A4 = D1.IDA2A2 AND
D1.IDA3MASTERREFERENCE = M1.IDA2A2 AND
RV.IDA3B5 = CN.IDA2A2;
Solved! Go to Solution.
Starting Windchill 10.2 M020 PTC has changed the way Classifications are stored and retrieved. The only way to achieve this is via Query Webject.
Refer to an article from PTC on this: https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS157536
I have attached an example webject for reference.
Same question. ReferenceValue is an empty table in my Windchill DB since the 10.2 update.
Any one to help?
Starting Windchill 10.2 M020 PTC has changed the way Classifications are stored and retrieved. The only way to achieve this is via Query Webject.
Refer to an article from PTC on this: https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS157536
I have attached an example webject for reference.