Query Builder Report - Parts linked to Resource

[GianpaoloGallo]

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 

[Marco_Tosin]

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

[Marco_Tosin]

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

[GianpaoloGallo]

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

[Marco_Tosin]

Try these

Whats is the link between a parent MPMresource and a child WTPart

[GianpaoloGallo]

Sorry Marco but I missed which kind of join I have to use.

Maybe It's not possible to have the direct link between WTPart and a resource.

My first idea was to use one link from WTPart to Process plan "where used" and Resources to Process plan "Where used"

Best regards

Gianpaolo

[GianpaoloGallo]

Hi Marco,

now I have the connection between WTPart of a "choosen" view and the process plan.

I need to use the link "where used" to connect Process plan to resource

 

Any Ideas?

Best regards

[Marco_Tosin · Accepted solution]

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)

[GianpaoloGallo]

Great Marco,

It works as well !!

Many thanks