Skip to main content
A
AN_107143724-Participant
4-Participant
November 15, 2023
Solved

report for CAD to Part structure comparison

  • November 15, 2023
  • 1 reply
  • 2710 views

How can I generate report for CAD to Part structure comparison with sql or any other query ? 

I know which tables are involved like PartUsesOccurrence, EPMBuildHistory, EPMDocument and EPMDocumentMaster, WTPart, WTPart Master but do not know how they are linked together 

 

Best answer by Fadel

partUsesoccurences holds info on the occurrences (generally reference designator /location [geometry]), this is needed particularly when we have usageLinks with Quantity > 1 and unit equal each , like a car with 4 wheels , we can have one Usage like with 4 ref designators to have 4 occurrences to identify each wheel  

Fadel_0-1700225838319.png

 

Fadel_1-1700225911781.png

again I'm more a windchill functionality guy , maybe someone with more knowledge in Creo/Windchill integration has more info on this   

 

1 reply

Fadel
Fadel23-Emerald I
23-Emerald I
November 15, 2023

Not possible using OOTB Query builder :

1- It not support recursive calls 

2- the structure resolving requires a config spec (filter) , not possible using QML 

 

 

Buiꓘa
A
AN_107143724-ParticipantAuthor
4-Participant
November 16, 2023

Do you have any query, either database or QML or any other for one level bom compare report ? Basically I need to know how those database tables are linked together  

Fadel
Fadel23-Emerald IAnswer
23-Emerald I
November 17, 2023

partUsesoccurences holds info on the occurrences (generally reference designator /location [geometry]), this is needed particularly when we have usageLinks with Quantity > 1 and unit equal each , like a car with 4 wheels , we can have one Usage like with 4 ref designators to have 4 occurrences to identify each wheel  

Fadel_0-1700225838319.png

 

Fadel_1-1700225911781.png

again I'm more a windchill functionality guy , maybe someone with more knowledge in Creo/Windchill integration has more info on this   

 

Buiꓘa
    Terms & ConditionsAccessibility statement