Query Report WTparts - CAD parts / CAD Assemblies

[GregOlson]

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.

[psingh-8]

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

[satre-2]

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_Tosin · Accepted solution]

In today news from TS:

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS190123

[GregOlson]

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

[Marco_Tosin]

[GregOlson]

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

[Marco_Tosin]

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