cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Query Report WTparts - CAD parts / CAD Assemblies

GregOlson
15-Moonstone

Query Report WTparts - CAD parts / CAD Assemblies

Does anyone have a report that will check to make sure there are WTparts created for all CADParts or CADassy files and spit back a list if the answer is NO?  If there is a way to select the product, that would be fantastic.  I looked through the reports already uploaded here and didn't see exactly what I was looking for.

1 ACCEPTED SOLUTION

Accepted Solutions
7 REPLIES 7

Hi Greg,

Have you tried to run a report on WTpart and EPMDoc using EPMBuildRule?

buildRule.IdA3A5=EPMDoc.branchIditerationInfo

and

buildrule.IdA3B5=WTPart.branchIditerationInfo.

For product:

WTPart.idA3ContainerReference=PDMLinkProduct.idA2A2

Not sure yes and no is possible through QML.You can try that with SQL.

Thanks

Pardeep

Below SQL will list all CAD document which does not have WTPart you can modify SQL as per your requirement

select A1.* from ControlBranch A0,EPMDocumentMaster A1

  where  A1.idA2A2=A0.idA3B5 and A0.idA2A2 not in ( SELECT A2.branchIdA3A5

FROM EPMBuildRule A2)

Hope it helps

Thanks

Shreyas

Marco...that must be from the case I opened with PTC.  Very quick turn around these days!

Marco

The report needs work...returning cad docs that DO have wtparts and have been built.  I let PTC know already.

Greg,

the report was already present in my document.

If/when TS will give you the right report I hope they will publish it on above article.

This way other people will be redirected to the right report.

Thanks

Marco
Top Tags