End Item object from Change Issue and Change Request

[adev]

Hello Team,

Can any one help to to get the Affected EndItem from the Change Issue and Change Request using Windchill api and dbtable

[satre-2]

use below API to get affected enditems for CR and see subjectprouct table in DB 

ChangeHelper2.service.getSubjectProducts(cr);

Thanks

Shreyas

[adev]

thank you Shreyas or your answer do you also know the database table from there we can get the endItem object

[BineshKumar1 · Accepted 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