topic Re: Uncompleted Report Query builder in Windchill

Uncompleted Report Query builder

GianpaoloGallo — Thu, 11 Jul 2024 12:41:17 GMT

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

Re: Uncompleted Report Query builder

Marco_Tosin — Thu, 11 Jul 2024 12:47:22 GMT

There is no picture attached to this discussion

Re: Uncompleted Report Query builder

GianpaoloGallo — Thu, 11 Jul 2024 12:49:30 GMT

Hi Marco,

please attached you will find the picture.

Best regards

Gianpaolo

Re: Uncompleted Report Query builder

Marco_Tosin — Thu, 11 Jul 2024 12:54:57 GMT

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.

Re: Uncompleted Report Query builder

GianpaoloGallo — Thu, 11 Jul 2024 13:17:48 GMT

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

Re: Uncompleted Report Query builder

Marco_Tosin — Thu, 11 Jul 2024 13:22:28 GMT

Report for latest version of Process plan with associated Part

Re: Uncompleted Report Query builder

GianpaoloGallo — Thu, 11 Jul 2024 14:58:59 GMT

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

Re: Uncompleted Report Query builder

Marco_Tosin — Thu, 11 Jul 2024 15:19:30 GMT

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

Re: Uncompleted Report Query builder

anursingh — Mon, 22 Jul 2024 19:27:02 GMT

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