cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

End Item object from Change Issue and Change Request

SOLVED
Highlighted
Newbie

End Item object from Change Issue and Change Request

Hello Team,

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: End Item object from Change Issue and Change Request

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

3 REPLIES 3

Re: End Item object from Change Issue and Change Request

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

ChangeHelper2.service.getSubjectProducts(cr);

Thanks

Shreyas

Re: End Item object from Change Issue and Change Request

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

Re: End Item object from Change Issue and Change Request

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