Looking for the joins for WTPart -> Change Notice

[vmcdaniel]

Hey guys,

Using report builder we want to enter a WTPart number and return all CR's/CN's all part versions is an Affected Object or Affected End Item.

Anyone have a QML I can start with?

Vaughn McDaniel III / KNA Engineering Automation

[MikeLockwood]

This CS is fairly good.

[atre.shreyas]

Attached are the sample report contain links between WTPart and Change Objects.

WTPart and Change Object

WTPart – RelevantRequestData2-ChangeRequest =Change Request’s Affected Object/WTPart

WTPart – ChangeRecord2-ChangeTask =Change ChangeTask’s Resulting Object/WTPart

Change Objects

ChangeNotice - AddressedBy2 – ChangeRequest

Hope this helps !!!

Thanks,
Shreyas