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

how to get the WORKPACKAGE data

SOLVED
Highlighted
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

Re: how to get the WORKPACKAGE data

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

2 REPLIES 2

Re: how to get the WORKPACKAGE data

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

Re: how to get the WORKPACKAGE data

Thank you so much Binesh