Skip to main content
V
Vignesh_AJ_778-Gravel
8-Gravel
February 20, 2024
Question

Folder information of parts in Windchill PDMlink

  • February 20, 2024
  • 2 replies
  • 1539 views
I am using Windchill PDMLink Release 11.2 and Datecode with CPS 11.2.0.5

HI, I am looking for a particular info in the database tables to build a report. Each part in windchill PDM has a location (Folder info) and I need to get that in my report. I gone through most of the tables in the PDMlink database, but could not find correct table.

Could you please help me with that info.

    2 replies

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    February 20, 2024

    Take a look at this article

     

    Report to list WTParts from folder

     

    You should also look at this page

     

    https://www.ptc.com/en/support/wnc-reporting-landing/

     

     

    Marco
      V
      Vignesh_AJ_778-GravelAuthor
      8-Gravel
      February 21, 2024

      Hi,

       

      Thank you for your response. I actually connected the windchill database to powerbi to take reports as I have a particular requirement to do that in powerbi.

       

      so, I am looking for this folder or location info in the database tables. 

      Marco Tosin
      21-Topaz I
      Marco Tosin21-Topaz I
      21-Topaz I
      February 21, 2024

      Have you read the article?

       

      The name of the table is written there

       

      Marco_Tosin_0-1708499943404.png

       

      Marco
        H
        Hari_Vara16-Pearl
        16-Pearl
        February 21, 2024

        Hi,

        Instead of looking into the DB , please use the means to report the OOTB attribute of the WTPart called "Location". 

        This is a easier way I think.

         

        Best Regards

        Hari

          V
          Vignesh_AJ_778-GravelAuthor
          8-Gravel
          February 21, 2024

          Hi,

           

          Thank you for your response. I actually connected the windchill database to powerbi to take reports as I have a particular requirement to do that in powerbi.

           

          so, I am looking for this folder or location info in the database tables. 

           

           

            Terms & ConditionsCookie settingsAccessibility statement