how to get the WORKPACKAGE data

[adev]

Hello,

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

[BineshKumar1 · Accepted solution]

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

[adev]

Thank you so much Binesh