Skip to main content
A
adev1-Visitor
1-Visitor
January 25, 2016
Solved

End Item object from Change Issue and Change Request

  • January 25, 2016
  • 1 reply
  • 2732 views

Hello Team,

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

Best answer by BineshKumar1

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

1 reply

S
satre-21-Visitor
1-Visitor
January 25, 2016

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

ChangeHelper2.service.getSubjectProducts(cr);

Thanks

Shreyas

    A
    adev1-VisitorAuthor
    1-Visitor
    January 25, 2016

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

    B
    BineshKumar11-VisitorAnswer
    1-Visitor
    January 26, 2016

    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

    Terms & ConditionsCookie settingsAccessibility statement