topic Re: Need a list of EPMDocument part numbers in Windchill

Need a list of EPMDocument part numbers

PK_10753886 — Wed, 13 Dec 2023 19:23:37 GMT

Hi,

I need a list of all EPM Document Part numbers from Windchill. I want the actual part numbers for EPM documents we have in the system. (Container based list of all products, containers and libraries)

It could be good if I'm given an instruction for this

Thanks

Re: Need a list of EPMDocument part numbers

avillanueva — Wed, 13 Dec 2023 21:19:52 GMT

Translating: You are looking for a report that shows all WTParts and what EPMDocument they are associated to?

Re: Need a list of EPMDocument part numbers

PK_10753886 — Thu, 14 Dec 2023 03:20:01 GMT

No, we need to get a list of all the part numbers for EPM Document

Re: Need a list of EPMDocument part numbers

HelesicPetr — Thu, 14 Dec 2023 06:46:20 GMT

Hi @PK_10753886

You can just create a report with EPMDocumetnMaster object and report the numbers.

here is a resource where you will learn how to create the Report in Windchill

Windchill Reporting Resource

If you need to add a condition based on a file number, then you would connect EPMDocumentMaster with EPMDocument.

Add a condition to report just a parts based on the "file name"

Hope this can help.

PetrH

Re: Need a list of EPMDocument part numbers

Marco_Tosin — Thu, 14 Dec 2023 07:34:35 GMT

Take a look also at this HUB article

[Knowledge Hub] Windchill PDMLink - EPMDocument Business Reporting

Re: Need a list of EPMDocument part numbers

Fadel — Thu, 14 Dec 2023 10:38:02 GMT

SELECT documentNumber FROM EPMDocumentMaster;

Re: Need a list of EPMDocument part numbers

HelesicPetr — Thu, 14 Dec 2023 10:42:19 GMT

@Fadel

Just for fun 😄 Try this with Windchill+

PetrH