Skip to main content
12-Amethyst
March 11, 2024
Solved

Query Builder Report - Parts linked to Resource

Hi,

I try to have a Report with latest version of WTpart related to a list of Resouce ( Workcenter,Tooling..).

There is someone able to help me please?

Best regards

Gianpaolo 

MarcoTosin
21-Topaz II
March 12, 2024

I have a report that links materials, equipment, cycles, operations, and work centers.

 

The name of the table labels are in Italian but it should not be difficult to retrieve the internal name from query builder.

 

The definitions table is used, trough criteria, to perform a join (my consultant's suggestion)

 

Marco_Tosin_0-1710227375504.png

Marco_Tosin_1-1710227490388.png

 

Marco

8 replies

MarcoTosin
21-Topaz II
March 11, 2024

Ciao Gianpaolo,
retrieving the latest version in the query builder reports is not exactly easy.

 

Below you can find some examples of ready-made reports containing the filter on the latest version for various types of objects

 

How to build a report for latest version of EPMDocuments

 

Report that lists the latest versions for documents

 

How to select the latest revision of a Part in a Query Builder report

 

 

Translate
Marco
MarcoTosin
21-Topaz II
March 11, 2024

In case you also have multiple views of the same object (Design, Manufacturing, Plant) it is even more complicated.

Here is a link to a discussion on the subject.

 

https://community.ptc.com/t5/Windchill/Report-to-list-WTParts-of-particular-view/td-p/96770

 

 

Translate
Marco
12-Amethyst
March 11, 2024

Hi Marco,

 

fetching the latest version is ok.

My scenario has 4 different Manufacturing Plants.

I need to build a report with connection between Resources and WTPart

Gianpaolo

Translate
MarcoTosin
21-Topaz II
March 11, 2024