Solved
how to get the WORKPACKAGE data
Hello,
Does any one know how do we can retrieve the data from the WORKPACKAGE using database script
BineshKumar1Answer
2-Explorer
February 17, 2016
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