topic Re: Folder information of parts in Windchill PDMlink in Windchill

Folder information of parts in Windchill PDMlink

Vignesh_AJ_77 — Tue, 20 Feb 2024 11:00:27 GMT

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.

Re: Folder information of parts in Windchill PDMlink

Marco_Tosin — Tue, 20 Feb 2024 11:11:08 GMT

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/

Re: Folder information of parts in Windchill PDMlink

Hari_Vara — Wed, 21 Feb 2024 05:05:39 GMT

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

Re: Folder information of parts in Windchill PDMlink

Vignesh_AJ_77 — Wed, 21 Feb 2024 06:19:52 GMT

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.

Re: Folder information of parts in Windchill PDMlink

Vignesh_AJ_77 — Wed, 21 Feb 2024 06:25:45 GMT

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.

Re: Folder information of parts in Windchill PDMlink

Marco_Tosin — Wed, 21 Feb 2024 07:19:44 GMT

Have you read the article?

The name of the table is written there

Re: Folder information of parts in Windchill PDMlink

HelesicPetr — Wed, 21 Feb 2024 10:39:54 GMT

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