Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Hello Team,
Can any one help to to get the Affected EndItem from the Change Issue and Change Request using Windchill api and dbtable
Solved! Go to Solution.
Try this
SELECT
wtc.wtchgrequestnumber as "CRNumber",
wtc.name AS "CRName",
wtp.name as "EndItemName",
wtp.wtpartnumber as "EndItemNumber"
FROM
WTPartMaster wtp,
WTChangeRequest2Master wtc,
SubjectProduct sp,
controlbranch cb
WHERE
wtp.ida2a2= sp.ida3a5 AND
sp.branchida3b5= cb.ida2a2 AND
cb.ida3b5=wtc.ida2a2;
Thank you
Binesh Kumar
use below API to get affected enditems for CR and see subjectprouct table in DB
ChangeHelper2.service.getSubjectProducts(cr);
Thanks
Shreyas
thank you Shreyas or your answer do you also know the database table from there we can get the endItem object
Try this
SELECT
wtc.wtchgrequestnumber as "CRNumber",
wtc.name AS "CRName",
wtp.name as "EndItemName",
wtp.wtpartnumber as "EndItemNumber"
FROM
WTPartMaster wtp,
WTChangeRequest2Master wtc,
SubjectProduct sp,
controlbranch cb
WHERE
wtp.ida2a2= sp.ida3a5 AND
sp.branchida3b5= cb.ida2a2 AND
cb.ida3b5=wtc.ida2a2;
Thank you
Binesh Kumar