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
  • 2704 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
R
rleir17-Peridot
17-Peridot
November 15, 2023

@AN_10714372 When you are looking at the 'gear' assembly, open the Actions menu:

rleir_0-1700079161467.png

I think you need to have an Owner link between the CAD assembly and the gear.

Terms & ConditionsAccessibility statement