How to query out (SQL Query on Oracle DB) classification in Windchill 10.2?

[RanjitG.]

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;

[amine.barhoumi]

Same question. ReferenceValue is an empty table in my Windchill DB since the 10.2 update.

Any one to help?

[RanjitG. · Accepted 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.