Skip to main content
1-Visitor
Jan 25, 2016 9:50 AM UTC
Solved

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

2-Explorer
Jan 26, 2016 3:04 PM UTC

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

1-Visitor
Jan 25, 2016 10:37 AM UTC

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

ChangeHelper2.service.getSubjectProducts(cr);

Thanks

Shreyas

Translate
adev1-VisitorAuthor
1-Visitor
Jan 25, 2016 11:59 AM UTC

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

Translate
2-Explorer
Jan 26, 2016 3:04 PM UTC

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

Translate