Query Report WTparts - CAD parts / CAD Assemblies

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