Uncompleted Report Query builder

[GianpaoloGallo]

I am using Windchill PDMLink Release 11.2 and Datecode with CPS 11.2.1.7

We missed items when fetching a report in query builder. in attached picture you can find the difference between search in Windchill and export Query builder. 7 items on 15 are complely missed.

Here are the errors that I faced
no

[Marco_Tosin]

There is no picture attached to this discussion

[GianpaoloGallo]

Hi Marco,

please attached you will find the picture.

Best regards

Gianpaolo

[Marco_Tosin]

I'm pretty sure the problem is caused by a join that should have an outer join for cases where the link between tables is not true.

[GianpaoloGallo]

great  !...it seems it works ...

but in this way the result include all the history between item and process plan...

I need to have only the latest version ....

any ideas?

Many thanks

Gianpaolo

[Marco_Tosin]

Report for latest version of Process plan with associated Part

[GianpaoloGallo]

No. even I use the  process plan branch identifier the result is the same.

Report gives all the revision attached to the same process plan.

Best regards

Gianpaolo

[Marco_Tosin · Accepted solution]

The link to the article I put up earlier refers to how to filter the LATEST version of the Production Plans.

To filter also the LATEST of the WTPart you have to use the same method, with the addition that, if you have multiple views, especially if views are of different plants, you have to make a sub-select for each of them (2nd link below).

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

Query Builder Report to query latest version of all WTParts in Windchill PDMLink

[anursingh]

Hi @GianpaoloGallo,

I wanted to follow up with you on your post to see if your question has been answered. 
If so, please mark the appropriate reply as the Accepted Solution. 
Of course, if you have more to share on your issue, please let the Community know so that we can continue to help you. 

Thanks,
Anurag