Windchill Reporting on Problem Reports with Affected End Items (from Part Master)

[FrancisMason]

Hi everyone.  I am trying to add Affected End Items to a "Problem Report" report with Report Builder (Windchill PDMLink 11.1).  I have successfully done the same for a "Change Request" report using the below guide but this does not work in the same way for Problem Reports.  Can anyone help?  I need to know what kind of join and any additional tables to go between the Problem Report table and the Part Master table.

(This is the link to the guide for Change Requests -> Affected End Items which works well.)

Affected End Items Part Master Report (ptc.com)

Thanks!

Francis.

[Fadel]

use table problem product :

[FrancisMason]

Thanks, I'm trying this but not getting any results.  Please share the select tab too.  Thanks.

[Fadel]

better, I will share the entire report as zip ,and you can import it to your base , let me know if you need help with the import

[FrancisMason]

Thanks for the follow up.  I will test some more and let you know.  I may even be working with a data set that has no affected end items against problem reports (which would explain the lack of results 😀 )

[FrancisMason]

Please also show the join screens.  I'm using the same as you but there must be a difference as I'm getting no results as soon as I add the Problem Product table and joins.

[FrancisMason]

Added an outer join and getting some results now.  Testing, but if you have any further info, it's all welcome.  Thanks

[Fadel · Accepted solution]

Hi , I don't have other points on specific joints , but I will tell you how I found the link .

1- created data set (PR with affected end Item)

2- find the Ida2a2 of the PartMaster :

3- run Plfind script (attached the one for Oracle ) to find all references for the PartMaster ID :

[Marco_Tosin]

Take a look at this article

QML report for Problem Reports and Affected Objects in Windchill PDMLink

[FrancisMason]

Thanks but that's a different thing.  Affected end items are not the same as Affected Objects.