Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. 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