Skip to main content
A
AM_104674965-Regular Member
5-Regular Member
March 7, 2024
Question

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

  • March 7, 2024
  • 2 replies
  • 1399 views
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

    2 replies

    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    March 7, 2024

    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

     

     

    Marco
      A
      AM_104674965-Regular MemberAuthor
      5-Regular Member
      March 13, 2024

      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

      MarcoTosin
      21-Topaz I
      MarcoTosin21-Topaz I
      21-Topaz I
      March 13, 2024

      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

       

      Marco_Tosin_0-1710313934152.png

       

      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).

       

       

      Marco
      S
      Syed_PLM16-Pearl
      16-Pearl
      March 13, 2024

      Hi Anil,,

       

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

       

      Let us know if that helps.

       

      regards
      ~Syed

      A
      AM_104674965-Regular MemberAuthor
      5-Regular Member
      March 13, 2024

      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. 

       

      AM_10467496_0-1710311013482.png

      Thank you for your time.

       

      Regards

      Anil

      Terms & ConditionsAccessibility statement