The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
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