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

report for CAD to Part structure comparison

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 

 

Fadel
FadelAnswer
23-Emerald II
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
View in thread

10 replies

Fadel
Fadel23-Emerald II
23-Emerald II
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 

 

 

Translate
Buiꓘ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  

Translate
Fadel
Fadel23-Emerald IIAnswer
23-Emerald II
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   

 

Translate
Buiꓘa
    Terms & ConditionsAccessibility statement