Hi Team, Please help me in generating a qml report All WTParts for which representation is missing.

[AM_10467496]

I am using Windchill PDMLink Release 11.2 and Datecode with CPS 11.2.1.17

Hi Team,

Please help me in generating a qml report All WTParts for which representation is missing. I tried from my side but I am not able to do it.

Regards
Anil

[Marco_Tosin]

Take a look at this article

Report to list all EPM Documents without representations

You can also look up what you asked for in the PTC Support KB.

https://www.ptc.com/en/support

You may also read this page

ptc.com/en/support/wnc-reporting-landing/wnc-reporting-landing-main

[AM_10467496]

Hi Marco,

Thank you for sharing the links. But my requirement is for WTParts with no representation. I tried to use the same logic and criteria that is used for EPM in the link for my requirement, but the report is pulling the WTParts with and without representation.

Anyway thank you for your time.

Regards

Anil

[Marco_Tosin]

Try to use this report and a sub select like the one in the EPMDoc report

Query Builder report to display WTParts having representations in Windchill PDMLink

And also this article could help

How are Representations stored in the database and how are EPMDocuments linked to them in Windchill PDMLink

• The CLASSNAMEKEYTHEREPRESENTABLE and IDA3THEREPRESENTABLEREFERENCE columns in the DerivedImage table can be used to identify the Representable (which could be a WTPart or an EPMDocument).

[shussaini]

Hi Anil,,

Have you tried creating a publish scheduler job. Refer the steps mentioned in CS338535.

Let us know if that helps.

regards
~Syed

[AM_10467496]

Hello Syed,

I have tried this before to get the report from WVS JOB SCHEDULER but it is giving results in below format shown in the image. It is very difficult to get the columns like container name, Latest iteration/version. this did not helped me. 

Thank you for your time.

Regards

Anil