Skip to main content
R
RanjitG.1-Visitor
1-Visitor
February 6, 2015
Solved

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

  • February 6, 2015
  • 2 replies
  • 3536 views

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;

Best answer by RanjitG.

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.

2 replies

A
amine.barhoumi1-Visitor
1-Visitor
February 23, 2015

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

Any one to help?

R
RanjitG.1-VisitorAuthorAnswer
1-Visitor
November 20, 2015

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.

Terms & ConditionsAccessibility statement