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

We are happy to announce the new Windchill Customization board! Learn more.

how to get the WORKPACKAGE data

adev
1-Newbie

how to get the WORKPACKAGE data

Hello,

Does any one know how do we can retrieve the data from the WORKPACKAGE using database script

1 ACCEPTED SOLUTION

Accepted Solutions
BineshKumar1
12-Amethyst
(To:adev)

SELECT DISTINCT wpm.name,wpm.packagenumber,epmM.name

FROM PersistedCollection pc,WorkPackage wp,WorkPackageMaster wpm, epmdocument epm, epmdocumentmaster epmM,PersistedCollectionLiveLink pcLink

WHERE epm.idA3masterReference=epmM.idA2A2 AND wp.ida3masterreference= wpm.ida2a2 AND (((pc.idA3A5 = wp.idA2A2) AND (pcLink.idA3B4 = epm.idA2A2)

AND (pc.idA2A2 = pcLink.idA3A4) AND (pcLink.roleBisSeed = 0))) ORDER BY wpm.packagenumber;

This should work. You have to join wtdocument as well to get documents.

Thank you

Binesh Kumar

Medtronic - MITG

View solution in original post

2 REPLIES 2
BineshKumar1
12-Amethyst
(To:adev)

SELECT DISTINCT wpm.name,wpm.packagenumber,epmM.name

FROM PersistedCollection pc,WorkPackage wp,WorkPackageMaster wpm, epmdocument epm, epmdocumentmaster epmM,PersistedCollectionLiveLink pcLink

WHERE epm.idA3masterReference=epmM.idA2A2 AND wp.ida3masterreference= wpm.ida2a2 AND (((pc.idA3A5 = wp.idA2A2) AND (pcLink.idA3B4 = epm.idA2A2)

AND (pc.idA2A2 = pcLink.idA3A4) AND (pcLink.roleBisSeed = 0))) ORDER BY wpm.packagenumber;

This should work. You have to join wtdocument as well to get documents.

Thank you

Binesh Kumar

Medtronic - MITG

Thank you so much Binesh

Top Tags