Folder information of parts in Windchill PDMlink

[Vignesh_AJ_77]

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.

[Marco_Tosin]

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/

[Vignesh_AJ_77]

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]

Have you read the article?

The name of the table is written there

[HelesicPetr]

Hi @Vignesh_AJ_77 

I just add a note that not just a WTPart can be part of folder,

It apply for EPMDocument, WTDocument, ChangeObjects MPMLink objects as MPMProcessPlan, MPMOperation 

generally all objects in the system that can be part of folder.

Each super type has own table in the database. 

PetrH

[Hari_Vara]

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

[Vignesh_AJ_77]

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.